Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SELECT RUNS SLOW FIRST TIME EXECUTED
Message
From
16/10/2000 17:57:13
 
 
To
16/10/2000 17:15:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00430042
Message ID:
00430062
Views:
8
It could be that the first time the application is reading un-cached data. After...it is reading cached data.

>I have an application that uses several 50k to 450k record tables and there are many different SQL Select statements. When these SQL Select statements are executed the very first time, it takes up to 4 times as long as it does every time after that. Any suggestions???
Thanks,
Dan Jurden
djurden@outlook.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform