Re: Using mysql_data_seek() is very slow

2001-06-18 Thread Benjamin Pflugmann
Hi. On Mon, Jun 18, 2001 at 08:16:45AM +1000, [EMAIL PROTECTED] wrote: What is the current way to move back and forwards and to any position in a recordset without losing performance There is no way. For effiency, the record set is hold in memory as linked list. Searching a position in

Using mysql_data_seek() is very slow

2001-06-17 Thread John Armstrong
What is the current way to move back and forwards and to any position in a recordset without losing performance I am testing MySQL I have 10 records in a table Using res = mysql_store_result( MYSQL ) ; int iRows = (int) mysql_num_rows( res ); for (i = 0; i iRows; i++)