Well, you haven't told us what database you're using at all, but I'll
assume MySQL. In which case you should look at the LIMIT part of your
query.
http://www.mysql.com/doc/en/SELECT.html
All you need to do is pass around a starting point variable on each
page, so that you know where the resul
a sample from my db class, i had to store the total in a session as calling
the total on every page on a large database was painful doing count(*) or
even SQL_CALC_FOUND_ROWS, on a small database u just cant tell but on a
database of 100k + it was painful to load each page ;)
function page_query($
100k = 100k records = 200 meg hehe
> a sample from my db class, i had to store the total in a session as
> calling the total on every page on a large database was painful doing
> count(*) or even SQL_CALC_FOUND_ROWS, on a small database u just cant
> tell but on a database of 100k + it was painful
If you're using CGI/Perl, WHY WHY WHY are you asking questions on a PHP
list?
I've given you a hint, so perhaps take that hint and ask a question on
an Oracle list, or search the Oracle documentation for similar
functions.
Justin French
On Tuesday, August 5, 2003, at 10:37 PM, Coello, David
4 matches
Mail list logo
