Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How much time to select records
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01415701
Message ID:
01415701
Vues:
97
I have query which selecting the records from table(8 mb) more than 40000. Its take 0.80 second I have a 1.4 sony vio laptp. I am feeling Its take time long. or it is well. Can any one tell me . how i can decrease time.
thisform.container6.searche.RecordSourceType=4thisform.container6.searche.RecordSource = "select word,ur from dict "+;
" where UPPER(word) = Upper(Trim(thisform.container6.texte.Value))"+;
" order by word into cursor SYS(2015) nofilter"