Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What to do when user SQL Selects too much?
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01105674
Message ID:
01105859
Views:
18
>>>>
>>>>What is your back end? You can do select count(*) first, then the actual select.
>>>
>>>Your suggestion of "count(*) first" is by far faster than select with TOP nnn. I think this should be the solution to the thread but they only allow one. Thank you very much.
>>
>>Do you want MY message to be marked as a solution then <g>? I can do that for you <g>
>
>Sure. Anything to make me happy <g>.

Looks like my screen resolution doesn't allow me to do that. Oh, well, not a big deal anyway <g>
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform