Speed Question: SQL Queries

[Joe_Krako]

Hi,

How long exactly does it take for a ColdFusion page to return results of the
following for a MySQL database:
a. 10,000 records
b. 1000 records
c. 100 records

I'm asking because I'm using a guy's CF tag that pages through results. And
when paging through the results,
it would grab the whole darn 10,000 records if there are 10,000 records.
Further, this is for a forum that could
actually become popular.

Does anyone here work with large databases who knows the answer to this
question?

Thanks in advance,

Joe

P.S. Better yet, anyone know of an already made ColdFusion programmed forum
for sale for very cheap or free?

[Joe_Krako]

Never mind. After messing with Google's URL, I guess I can figure out how to narrow down the query return.

[shp.jc]

You could also consider CF's built in query caching feature.