Some Table with 500 000 records.
Hi people. :)
I will use the Java language first in my life.
Before this time I used VS2005 .NET. So I hope you will help me, please. I'm using NetBeant 5.5.1 + Visual Web Pack 5.5.1 + FireBird 2 + GlassFish v2. And I have liked RowSet + DataProvider. But i found some article about RowSet.
http://java.sun.com/developer/Books/JDBCTutorial/chapter5.html
So they said next:
Rowsets may have many different implementations to fill different needs. These implementations fall into two broad categories, rowsets that are connected and those that are disconnected. A disconnected rowset gets a connection to a data source in order to fill itself with data or to propagate changes in data back to the data source, but most of the time it does not have a connection open. While it is disconnected, it does not need a JDBC driver or the full JDBC API, so its footprint is very small.Thus a rowset is an ideal format for sending data over a network to a thin client.
Because it is not continually connected to its data source, a disconnected rowset stores its data in memory. It needs to maintain metadata about the columns it contains and information about its internal state. It also needs a facility for making connections, for executing commands, and for reading and writing data to and from the data source. A connected rowset, by contrast, opens a connection and keeps it open for as long as the rowset is in use.
So could you recommend me somewhat for big Table?
Regards
Michael
