List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:January 30 2000 7:52am
Subject:Re: ANSWER: mysql_value(res,i,j) wanted :-)
View as plain text  
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
Thread
mysql_value(res,i,j) wanted :-)(Alexander Barkov)28 Jan
  • Re: mysql_value(res,i,j) wanted :-)sinisa28 Jan
  • ANSWER: mysql_value(res,i,j) wanted :-)Michael Widenius29 Jan
    • Re: ANSWER: mysql_value(res,i,j) wanted :-)Benjamin Pflugmann30 Jan
      • Re: ANSWER: mysql_value(res,i,j) wanted :-)Michael Widenius30 Jan
        • Re: ANSWER: mysql_value(res,i,j) wanted :-)Benjamin Pflugmann30 Jan
          • Re: ANSWER: mysql_value(res,i,j) wanted :-)Michael Widenius5 Feb
  • dump errorkevin7 Feb
    • Re: dump errorsinisa7 Feb
  • DATE arithmaticKevinWaterson21 Feb
    • Re: DATE arithmaticsinisa21 Feb
    • Re: DATE arithmaticVivek Khera21 Feb
  • triggers ?KevinWaterson12 Mar
    • Re: triggers ?Jonathan Stimmel12 Mar