Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow Browse on 1.5 mil table & slow query.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00344424
Message ID:
00344437
Views:
27
Dawn,

One challenge with attempting to help in these situations is not knowing the experience level of the person posting the question. Please bear with me while I run through some more likely places to look, which may be elementary to you...

>1. 0 and I do have a deleted tag

Have you tried it without the deleted tag? With zero deleted records, it might make a big difference. There have been several discussions here about that in recent months.

>2. different sets based on the query
> on 1 test 13 records back

On the 13-record test, which took 1 - 2 minutes I presume, did you have values in all of the query parameters?

And what version of Fox are you running?
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform