Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to speed up SQL statment
Message
 
 
To
06/05/2003 08:29:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00785250
Message ID:
00785291
Views:
14
>>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform