> You can load sqlite into memory? > I do have 2GB of RAM. You can pass ":memory:" to the sqlite_open command to open a SQLite database in memory I think it is
I imagine this will speed up your retrievals but without an index it will still be slower that it should be. With an index I imagine your test should have been sub 1 second to return that select statement
