database persistence with mysql, sqlite

[Lawrence D'Oliveiro]

In message <1190502677.970811.181100 at 22g2000hsm.googlegroups.com>, coldpizza
wrote:

> So far, with mysql I use 'SELECT * FROM TABLE LIMIT L1, L2' where L1
> and  L2 define the range for the 'Next' and 'Previous' commands. I
> have to run the query every time a click a 'Next/Prev' link. But I am
> not sure that this is the best and most efficient way.

Try it first, then see what happens. Remember, premature optimization is the
root of all (programming) evil.