Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Every successive SQL select takes longer
Message
From
31/05/1999 06:05:45
 
 
To
30/05/1999 12:35:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00224342
Message ID:
00224620
Views:
18
>Peter,
>

>That said, SP3 is the first to have *specific* VFP fixes, and there are tons of them. The summary lists:
>Q191172: Performance degradation with Repeated SQL SELECTs

Sounds like my baby!


>Q197510: Poor performance with Forms Cantaining Many Objects

They're working on this, good.



>Finally, I'm not so sure that a CLOSE DATA ALL is the same as a CLOSE ALL.
>
>Good luck,
>
>Jim N


It occured to me after I posted that I was making that assumption. I should check to make sure. I did check for open files with a SET after the CLOSE DATA ALL and there were none.

Peter
Peter Robinson ** Rodes Design ** Virginia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform