Why does paginate call the database twice?

[eluser]madeks[/eluser]
Hi,

I'm don't mean to dig the death here but as I got the same problem with "gh0st" and he seem to disappeared.

It's definite thanks to "m4rw3r", the solution is worked!!!.

I have quite similar problem. I got 20k row with more than 70 fields from DB to do some stat calculation.
It use 90 MB only for this processing. No doubt it is out of memory on my local.

After this thread, I found one stupid mistake in my code.
As you can guess we don't use all fields to do the stat calculation.
So I change it to select only the fields that need a calculation.

The result is beyond good. The memory usage is reduce to only 15MB.

So I decide to share it here in case someone got the same problem as mine.