in reply to Re: Out of Memory selecting from MySQL
in thread Out of Memory selecting from MySQL

I've gone with batching 100k rows at a time Goes fast enough (for now), but I'll keep the pre-size thing in mind for future ref.

Even with 100k rows at a time, pre-sizing the array would probably show a measurable performance improvement due to the removal of the need for doubling and copying. And it won't cost you anything.


Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
"Too many [] have been sedated by an oppressive environment of political correctness and risk aversion."
  • Comment on Re^2: Out of Memory selecting from MySQL