Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What to do when user SQL Selects too much?
Message
From
21/03/2006 12:56:16
 
 
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:
01106295
Views:
32
>Hi,
>
>>>Google does exactly what I'm advocating - gives you a count (and then obviously not by a query against the full base). You can't download the 8,790,000,000 hits in one go - just a maximum of 100 per page. And that's *still* not the actual pages - just the links.
>>
>>I'm sorry, but I don't understand. You did say you would REFUSE to query.
>
>I said "Could you do a COUNT first and refuse to pull the actual data if the result size was too large?". Not the same thing at all.
>
>Best,
>Viv

You two have been at this for 8 hours! If you were boxers you'd be leaning on each other, head-to-head :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform