Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox dropdown for 400k records search
Message
From
21/09/2006 00:49:09
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:
01155810
Views:
22
Set deleted is on
no index on deleted()
cpdbf() and cpcurrent() are both 1252.
already indexed on prodcode field.
What would be the normal query time for 415k records to run :-
select count(*) from tstokmast.
I've got 25 seconds.
Yau
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform