mysql_use_result issue: useless iterating over unused results

2005-01-11 Thread Renald Buter
Hello list, I am having this issue with mysql_use_result: it seems it will iterate over all unused results if I call 'mysql_free_result'. The following code illustrates this: mysql_query(mysql,SELECT * FROM a_very_large_table); res = mysql_use_result(mysql); i = 0; while (row =

mysql_use_result issue: useless iterating over unused results

2005-01-11 Thread Renald Buter
Hello list, I am having this issue with mysql_use_result: it seems it will iterate over all unused results if I call 'mysql_free_result'. The following code illustrates this: mysql_query(mysql,SELECT * FROM a_very_large_table); res = mysql_use_result(mysql); i = 0; while (row =

Re: mysql_use_result issue: useless iterating over unused results

2005-01-11 Thread Karam Chand
Yup. This is a normal behaviour. mysql_free_result() will result in bringing each unasked rows to the client and freeing it up row by row. BTW, why do you need to do - select * from Karam --- Renald Buter [EMAIL PROTECTED] wrote: Hello list, I am having this issue with

Re: mysql_use_result issue: useless iterating over unused results

2005-01-11 Thread Renald Buter
On 01:55 Tue 11 Jan , Karam Chand wrote: Yup. This is a normal behaviour. mysql_free_result() will result in bringing each unasked rows to the client and freeing it up row by row. This sounds to me as a useless feature. What could be the reason for such wasting behaviour? BTW, why

Re: mysql_use_result issue: useless iterating over unused results

2005-01-11 Thread Karam Chand
I am not sure why they are doing it. You need to hack the protocol to understand it. Maybe some MySQL/network GURU will be able to help yuo. Regards, Karam --- Renald Buter [EMAIL PROTECTED] wrote: On 01:55 Tue 11 Jan , Karam Chand wrote: Yup. This is a normal behaviour.