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. mys

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? > BT

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 mysql_us

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_fetc

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_fetc