database persistence with mysql, sqlite

[Lawrence D'Oliveiro]

In message <HSnKi.35782$RX.34622 at newssvr11.news.prodigy.net>, Bryan Olson
wrote:

> coldpizza wrote:
>> It turned out that the method above ('SELECT * FROM TABLE LIMIT L1,
>> L2') works ok both with mysql and sqlite3, therefore I have decided to
>> stick with it until I find something better. With Sqlite3 you are
>> supposed to use LIMIT 10 OFFSET NN, but it also apparently supports
>> the mysql syntax (LIMIT NN, 10) for compatibility reasons.
> 
> A more reliable form is along the lines:
> 
>      SELECT keyfield, stuff
>      FROM table
>      WHERE keyfield > ?
>      ORDER BY keyfield
>      LIMIT 10
> 
> With the right index, it's efficient.

But that involves keeping track of the right starting keyfield value for the
next batch of records, which is complicated and nontrivial. Simpler to let
the DBMS do the work for you.