Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What to do when user SQL Selects too much?
Message
De
21/03/2006 12:56:16
 
 
À
21/03/2006 12:51:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01105674
Message ID:
01106295
Vues:
30
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform