First of all, I
assume that limiting the number of records will be much faster in the query than
in the cfoutput, correct? If you do the 'ol startRow and endRow, isn't it
pulling all of the records anyway.
Second, if this is
the case, what is the best way to handle the next, previous, etc. I ask
because the table that I am pulling from has hundreds of thousands of records
and I only want 250 at a time.
Thanks,
Kevin
