> a shot in the dark. Try
>
> SELECT * from bridge_table WHERE timestamp < 1167615601;
>
> although, it would probably not help because SQLite would still have
> to scan the table to ascertain there were no more rows that met the
> criterion. My hunch is that without giving the program some hint (aka,
> INDEX) you can't get what you want. But, others on this list likely
> have much better knowledge of the internals.
Unfortunately, that doesn't solve the issue of needing to scan all
the records in the database (without an explicit INDEX), since SQLite
doesn't realize and thus doesn't act on the fact that the data in the
timestamp column is already sorted.
Chris
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
