[PHPLIB] show_page in table.inc From: admin (admin <email protected>)
Date: 12/09/99

Would there be any reasonable performance gain in using LIMIT in an sql
query to print pages of results, instead of seeking to the desired record
and printing a number of records in a while loop?

I have been tweaking table.inc and I'd think there would be an advantage
to using LIMIT, but I don't know how I can actually test or predict the
usefulness of such a hack. I am also using SORT in my sql queries, so
perhaps the db server will have to retrieve all records beforehand anyways
in order to perform the sort. In such a case, I guess using LIMIT wouldn't
make much of a difference. On the other hand, there are perhaps cases when
using LIMIT would make a difference.

Any guidance would be appreciated to solving this problem.
Thanks in advance,
Marc

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.