I had similar thoughts to Simon.... How are you keeping track of "frequently queried"?? Seems to me that has to either be in-memory in your program or a database update. Either of which seems like a waste of time. So you have to update some structure to keep track of frequency...do a query...do an insert where appropriate...query the other table when not found...insert into other table when appropriate... Have you proven to yourself that the indexing the table itself is too slow? What did you do to test that? How many records are you talking about? I've got a real-time system I'm working on...I have one index on my tables. I can tell you it makes absolutely no difference if the database is on-disk or in-memory (I'm doing 5-second transactions). Now I'm not really data-base bound but others have noted similar disappointment when expecting too much out of in-memory performance. http://stackoverflow.com/questions/764710/sqlite-performance-benchmark-why-is-memory-so-slow-only-1-5x-as-fast-as-di Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of srl309 Sent: Sat 1/8/2011 3:45 AM To: sqlite-users@sqlite.org Subject: EXTERNAL:Re: [sqlite] Pin index to memory 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
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
