Rob, Try creating indexes without order.
Or, try to make a column with a hash of the values entering the index and search for the value by the index of. This will complicate the logic of your program, but it will decrease the volume of the database, and possibly significantly speed up both reading and writing. --- Anton Azanov -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users