General information
Title:
Fastest way to populate combobox with 10t+records
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only