Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL speed difference
Message
 
 
To
12/08/1997 05:26:40
Siu-Hung Lai
The Hong Kong University of Sci. & Tech.
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00044159
Message ID:
00044352
Views:
27
>I have 6 SQL command in a prg to retrive data into a cursor from 3 tables(with 9000,180,000 and 340,000 records). When I run the prg from project manager, it takes 37 secs. If I run it in the Form.Load(), it takes 60 secs. What is the possible cause?
>

Siu-Hung,

Ensure that you have an indexes on all the appropriate fields. (Sorry if this sounds obvious, but I have been caught this way a few times).
Previous
Reply
Map
View

Click here to load this message in the networking platform