Re: Problem with many connections

[John Zandbergen]

Weird, seems like the server is waiting for your application to free a lock?

Anyway:
It might have something to do with the results of which you are not freeing the memory.
After working with your data you should free the memory of the store-result with:
mysql_free_result(res_set);

Also, consider bringing the opening and closing of the connection outside your while-loop. You have to make and release a connection ony once as far as I can see it in your code.

HTH,
John