Re: Just one row

[Johan Engström]

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