memory matter in fetching

[Anon]

Is there a difference about the amount of memory wasted if I fetch all records to an array at a same time then use mysql_free_result() to free all records? Can you tell me any other differences like speed efficient... Thanks.

[[deleted]]

I'm not sure what you mean, if you copy all records into an array, you'll need twice the amount of memory untill you call free-result to free the resultset memory.

Differences in speed, depends on how many records you have. If you have 500k records in a resultset, you'de be quite insane to copy them.

Do a benchmark and see :-)

[Anon]

Yes, that's exactly what I mean. But how does it work though? Because mysql_fetch_array() got to get the record somewhere in memory. Thanks for the answer.