[thelist] limit of large query result sets

[Michael Mell]

Using PHP/MySQL, should I limit my select results to some small number
and process the data in batches?
Is the number of rows as important as the size of the data?

I have a MySQL query which results in about 60,000 rows.
Each row contains 5 columns with a total of about 64 characters.
My calculations show this to be about 3.6 megs of data
(64 X 60,000 / 1024 /1024)
on a machine with at least 500 megs of RAM and little else to do at the
time of processing.

Obviously there seems little danger of overload. I'm just wondering
about the limits of the system.

--
mike[at]nthwave.net
llemekim         YahooIM
415.455.8812     voice
419.735.1167     fax