"ryc" <[EMAIL PROTECTED]> wrote:
> When performing a query that will return a large dataset (by large I mean
> 100k+ rows), is it more effecient (memory usage wise) to use the results
as
> you fetch them or fetch all the results into an array, free the statement
> handle, and the process from array? What about performance wise? I am
using
> perl w/ DBI, but I assume it would be the same if I were using the C api
as
> well.
Processing the records as they are being returned by the query is faster and
more efficient than writing the records to an array and then processing the
array.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
