Re: ANSWER: mysql_value(res,i,j) wanted :-)

[Michael Widenius]

Hi!

>>>>> "Benjamin" == Benjamin Pflugmann <philemon@stripped> writes:

Benjamin> Hi.
Benjamin> If you don't really use random access most times, but just want to
Benjamin> have a "pretty" interface, you can work around the slow
Benjamin> mysql_data_seek by caching intermediate results:

Benjamin> I have done this myself in a C++-Wrapper for access via result[i][j]
Benjamin> after I first used a big result set and noticed how slow
Benjamin> mysql_data_seek() can be. ;-)

Note that I in my pfunctions used my_row_seek() which is VERY fast!

Benjamin> The respective function follows (Row is a class able to hold infos
Benjamin> about a record and will allow to access the columns). Note, the
Benjamin> interesting part is the check whether index matches CurrentRow or
Benjamin> CurrentRow+1.

Regards,
Monty