Thanks for replying but i don't think that will do what i want. I am trying to create a system that will save frequently queried values that are not indexed to index's. The total amount of indices allocated this way would have a set size and would be dropped and created depending on how often they and other values are used. I was thinking since these indices are used frequently it would be a good idea to save them to memory dropping them when the connection closes.
The values saved to index's should act like index's. As in if i query their table they should be used. -- View this message in context: http://old.nabble.com/Pin-index-to-memory-tp30620303p30620918.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