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 10:01:04
 
 
To
21/03/2006 08:54:37
Mike Yearwood
Toronto, Ontario, Canada
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:
01106213
Views:
28
Hi Mike,

>Funny, Google lets anyone pull a query on just about anything. A query for the single letter A returns 8,790,000,000 hits. If the user wants to scroll through all of those records, it lets them.
>
>It's our job to support the users with enabling technology. Google does this with pagination, but it REFUSES to search.
>

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.

>>>Backups take hours. Should the backup software REFUSE to run?
>>Backups are different argument. They can run in the background, at a lower priority, be scheduled for low usage periods and don't neccessarily affect network bandwidth.
>>
>Actually, they are not a different argument. It's a piece of software running in a particular environment. It's often required to backup all files across the entire network. The backup programmers don't build in code that says if the backup operator (user) wants to run the backup at 3 in the afternoon REFUSE to do it.

Surely not every user is a backup operator? Maybe we're just used to working in different environments. If you grant someone backup priveledges then the assumption should be that there capable of making reasonable decisions on the backup strategy. IAC backup isn't going to make much demand on the processor.

Regards,
Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform