Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox dropdown for 400k records search
Message
From
18/09/2006 14:17:30
 
 
To
18/09/2006 14:15:06
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01154761
Message ID:
01154826
Views:
12
>Naomi,
>I've put the check for the number of records in place and changed the display to use a grid.
>I'm also limiting the initial display to the top 50 records. Even this took almost 3 minutes for the screen to popup (on my local machine!)
>Do you have such speed issues on yourside? If so, (indexes already exist for the fields queried), any way to speed up the query?
>Yau

Selecting 50 records should be instant. You must show us the query if you want sugestions.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform