QuickTable | Thread - How does quicktable loads data from database?

QuickTable
Home \| API \| Tutorial \| Download \| Support \| Contact

QuickTable

User Cp | Register | Members | Search | Help

\|- QuickTable Discussion Forums > JDBC/Database Issues	Post New Topic Post A Reply
How does quicktable loads data from database?	printer friendly version next newest post \| next oldest post

Author	Messages
john_dunning{@}ameritech.net Unregistered	Posted Wednesday, December 31, 1969 @ 23:59:59 Your website states that ?Data for the table is fetched only when necessary, which minimizes the memory usage?. Can you, in detail, explain exactly what is meant by that statement? I am trying to determine if QuickTable has a thread that handles retrieving rows from the result set in the background while the user is presented with the gui, or if QuickTable goes back to the database when the user actually scrolls around. We need to be able to populate a JTable with many (hundreds to thousands) of rows, but want the user to get the gui presented with the first page or two of information as quickly as possible, instead of waiting for all rows to be returned. Any information you could provide about your product would be appreciated. Thanks! John Dunning
admin{@}quicktable.org Unregistered	Posted Wednesday, December 31, 1969 @ 23:59:59 On executing the query, quicktable scrolls through the resultset using resultset.next() until the record that will be visible in the jtable. So if there are 10,000 records & only 10 records are visible , the resultset.next() will be called 10 times. In this way, we are lot loading the whole 10,000 records but only 10. Once the user starts to scroll, we call the additional resultset.next() as needed. The data loading is not done in a separate thread, instead it is done in the same event thread. Quicktable avoids loading of the whole 10,000 records at the startup , instead it loads from resultset on demand as user scrolls down.

Post New Topic Post A Reply

Jump to:

All times are GMT -5 Hours.

Welcome to QuickTable Forums, Guest!

Username	:
Password	:

In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!