Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server slower than VFP?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00250319
Message ID:
00251558
Views:
16
Hi, Mike

Yes, I've tried limiting the results to 500. Actually, the stats I listed originally (something like 30 seconds) was with this limit in place. Without the limit, the 12,000 records takes some 2+ minutes!
You're right, though: users should not have to view such a large selection. This could be the key in this type of task. Unfortunately, I have other apps that users do want to scroll through all records (no matter how large), I suppose to get a feel for trends or such. So I may have to approach this problem later, anyway.
Mark

>The Advanced Options menu in the View Designer has an area that allows you to limit the size of your result set to a specific number of MAX RECORDS. You could create a parameterized remote view as show earlier then check _TALLY for the number of matches. If this equalled your predetermined MAX RECORDS, alert the user to be more specific and reissue the query.
>
>If your users are at all like mine, I am sure they would not want to scroll through a list of over a hundred or so names.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform