T
Thomas Mercer-Hursh
Guest
I guess I am not sure whether there is something interesting here. If one is doing this on sports, then the table isn't all that big and the DB activity is not going to be that great ... especially if still in -B. But, in any case, returning all records vs returning none seems like a big difference in the amount of work done. And, are we sure that the WHERE FALSE is really doing all the same DB work? And, yes, I get that server-side resolution has a major impact on performance of a network query ... run this same test networked if you want to see a dramatic difference. My point is just that WHERE FALSE is not a real world example because it provides no index selection and yet reads every record. Much more typical are conditions which provide index selection, reducing the number of records read. All of which is beside the original point which was that ABL is particularly slow at network queries.
Continue reading...
Continue reading...