Ian Walters <[EMAIL PROTECTED]> writes: > > Hi, > > What I'm trying to do is create an ordered table in SQLite that I can > then look up by row number. If performance isn't considered this is > actually quite easy. For example > > CREATE TEMPORARY TABLE mytable AS ... complex select statement ordered > by label, recordId ....; > CREATE INDEX ON mytable (label, recordId); > > SELECT recordId, label FROM mytable ORDER BY label, recordId LIMIT 1 > OFFSET row; ... > > -- > Ian
You could immediately reduce the per-row overhead of the SELECT by retrieving more than one row, as many as your working storage would allow. MikeW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users