Re: query memory usage

2001-04-12 Thread Steve Werby
"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 arra

query memory usage

2001-04-12 Thread ryc
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 usin