Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How this query will fast
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01468545
Message ID:
01468549
Views:
63
>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!
____________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform