List:General Discussion« Previous MessageNext Message »
From:Johan Engström Date:June 3 1999 6:34am
Subject:Re: Just one row
View as plain text  
Hi there!

> against the same table, same machine, unloaded
> other than that query, it took 0.89sec to do
> SELECT * FROM TABLE LIMIT 2000000,1;
> 
> and 0.48 seconds to do
> SELECT * FROM TABLE LIMIT 200000,1;

I just came to wonder, how much the performance of
this query depends on wether the table is of fixed-length
or variable-length row-format?

Cheers,

Johan

Thread
Just one rowJamie Lay2 Jun
  • Re: Just one rowAndrew J. Talbot2 Jun
  • RE: Just one rownkolb2 Jun
  • Re: Just one rowwintermute2 Jun
    • Re: Just one rowSteve Ruby2 Jun
      • Re: Just one rowYing Zhang3 Jun
        • Re: Just one rowSteve Ruby3 Jun
          • Re: Just one rowjohan.engstrom3 Jun
          • Re: Just one rowMichael Widenius3 Jun
            • Re: Just one rowSteve Ruby3 Jun
        • Re: Just one rowCharles Kirby3 Jun