Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How much time to select records
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
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=4
   
     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) nofilter"
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform