Dear Friends, I´m programming in C, Linux envirnment.
The SELECT´s results are being brought to the client by using mysql_store_result. And the result sets are being released by mysql_free_result. The problem is: as mysql_free_result is called, the system memory is NOT actually released. For example: I can monitor the program size in memory with "top" Linux utility (Conectiva 7.0 distribution). As the program is loaded into the memory, its size is, say, 1900Kb. Then, a select with a ruge result set is called and uploaded to the client. At this time, the program size in memory is 6000Kb. Then mysql_free_result is called. The program size in memory does not change. Isn´t it supposed to shrink back to 1900Kb? Thanks, folks!!! Leandro M Neves, Rocar Pcs Ltd, IT Manager Sete Lagoas/MG - BRAZIL
