database persistence with mysql, sqlite
ldo at geek-central.gen.new_zealand
Mon Sep 24 06:23:46 CEST 2007
In message <1190502677.970811.181100 at 22g2000hsm.googlegroups.com>, 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