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.
|
|---|