Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to speed up SQL statment
Message
 
 
À
06/05/2003 08:29:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00785250
Message ID:
00785291
Vues:
23
>>What is it about your form seems to be the question.
>
>The form is set exactly like desktop window except datassesion, which is private in form, and default in screen.
>
>>Does it open lots and lots of tables?
>
>It's only one table with 90000 records.
>
>>Does it use lots of RAM for arrays or other stuff?
>
>No it doesn't.
>
>>Is there somewhere in the form where optimization is turned off?
>
>No.
>
>>Is there possibly some anti-virus software running where the form is run >that makes the environment different?
>
>No.
Goran,

Use SYS(3054,11) to see the level of optimization from command window and from the form. It may give you a clue what's different and causes slowdown.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform