In oracle you can do this Alter index <indxname> storage (buffer_pool keep); This would keep the index in memory thus allowing it to be read quicker. Is there any way to do this in sqlite without the table or database being in memory.
If there is not does anyone have any ideas on functions i can manipulate in sqlite3.c to get the ability to store indices in memor -- View this message in context: http://old.nabble.com/Pin-index-to-memory-tp30620303p30620303.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
