Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fastest way to populate combobox with 10t+records
Message
From
08/09/2006 10:45:03
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Fastest way to populate combobox with 10t+records
Miscellaneous
Thread ID:
01152310
Message ID:
01152310
Views:
124
I have just migrated to a client-server environment with mysql as backend. However i've just encountered a problem with very slow form loading due to both slow hardware and the nature of disconnected record-sets, since i have to pull all the data from mysql to populate a combobox. I'm looking for an optimum solution in which a combobox just needs to pull just enough data (from mysql) for what is visible, like, if i may make an analogy, how vfp opens dbfs. When VFP opens a dbf, i doesn't load the entire file. Issue a use command and a table opens without delay . yet browse and you can pagedown or go to the bottom using the vertical slider. i think as you pagedown vfp fetches the corresponding data as needed from disk. I've tried asynchronous data access but it's not d same. you still have to wait till it fetches all data to be able to go to the end of the generated cursor. I mean to open a table and go to the last record, the computer just has to open the file and access first few and the last few records in order to emulate GO TOP, and Go bottom successfully. It doesn't have to load all data continuously (even in an asynchronous access which wastes processor time)..I've read that combobox is not suitable for large records but it's not negotiable since i was able to do it in a non-client-server environment and my client is insistent on having the incremental combobox feature.
Next
Reply
Map
View

Click here to load this message in the networking platform