John Jenkins <u2guru <at> btinternet.com> writes: > > What's the volume here? Adding the ORDER BY clause will cause the data to be > pre-processed before the result set starts to get returned. > Also, if you ignore how long it takes to *start* returning the result set, > how do the two compare in returning the *complete* result set? > > Regards > > JayJay >
The volume is about 4000 records, that "become" about 20000 once their multivalues are exploded. The difference in time to return the whole result set is huge: about 20 seconds vs. 5 minutes. Both are returning the same records. Just one sorts them and one doesn't. I've tried secondary indexes but there was no difference in speed. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
