mysql_store_result() @ MySQL C API - does it really allocate memory in each call?

Question

Hi!

I've read that mysql_store_result() in the MySQL C API will allocate memory for each and every call to it;

mysql_store_result() reads the entire result of a query to the client, allocates a MYSQL_RES structure, and places the result into this structure.

It is really so? I'm asking because I'm about to call it many times in a server application. Allocating/Freeing is horrible for my purpose.

Is there a way to provide a custom buffer to it? Maybe some "undocumented" API?

Answer 1

See this link about using mysql_use_result: http://dev.mysql.com/doc/refman/5.0/en/mysql-use-result.html

i use "use_result" instead of "store_result" on all select queries.

Answer 2

Yes, it's really so. Why wouldn't it be?

Perhaps you mean to edit your question to be, "What can I do instead?" rather than "Is it really so?" Based on your comments, that seems to be more what you're actually wanting to know.