Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combobox dropdown for 400k records search
Message
 
 
À
18/09/2006 14:15:06
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01154761
Message ID:
01154835
Vues:
13
>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

What is your back-end? Can you show one of the possible Select-SQL?

We don't have this problem here. If I have all indexes, the result comes almost instantaneously.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform