Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How this query will fast
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01468545
Message ID:
01468549
Vues:
56
>How this query will work fast. It has 37000 records, and takes .28 time to load.
>
> thisform.container6.searche.RecordSourceType=4  &&grid
> 
>     thisform.container6.searche.RecordSource = "select word,ur from dict "+;
>                " where UPPER(word) = Upper(Trim(thisform.container6.texte.Value))"+;
>                " order by word into cursor SYS(2015)  "
>
Is it returning 37000 records or it it querying a table that has 37000 records total? If you are pulling 37000 records then it will take a noticable amount of time just to transfer the data.

You'll need an index on Upper(word).
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform