On 8 Jan 2011, at 5:36am, srl309 wrote: > 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
Create a new table in memory with just the fields that you care about for that index. <http://www.sqlite.org/inmemorydb.html> <http://www.sqlite.org/lang_attach.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
