by lesouef » Mon May 10, 2010 6:09 pm
local = smart client on the LAN.
I am not asking you to change the defaults, but to be able to alter it when necessary.
why would I do this? we obviously have not been facing the same situations...
for instance, I am making stats on the content of a certain field. the result is wrong, so I must check what wrong codes have been entered (another app is taking care of data entry and makes no check on field contents), but I don't even know what kind of pattern to look for, so I need to read the table until I get a hint about what could have been badly entered. Say I want first to inspect the latest records manually, I need to scroll and scroll untill the 5000th? that's 25 clicks! and sorting will only sort the 1st 200, so no way to get the last first ... so unless I script everything, manually I have no excel like mode to inspect the table. when I use sql, I can say top 100000, if it takes too much memory, that's my problem.
Of course, all your good reasons are true to limit memory, bandwidth, but under some circumtances, it would be nice to view the whole table if I wanted it.
So the ideal is to keep your default value, but be able to alter it for let's call it "data inspection".