database persistence with mysql, sqlite

Lawrence D'Oliveiro ldo at geek-central.gen.new_zealand
Mon Sep 24 06:23:46 CEST 2007

In message <1190502677.970811.181100 at>, coldpizza

> 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.

More information about the Python-list mailing list