Hi, atm i'm developing an open source instant dictionary lookup tool wadoku-notify (wadoku.de japanese german dictionary)
for speed improvement i used fadvise function to let the kernel load the db file into memory, but now i ported the app to windows and mac os x and i let sqlite do the ram loading over a memory database and sql attach command. now i switched to an Fulltext search table FTS3 which improved speed drastically but it now need over ~15s on my 3Ghrz to load all entrys into the ram FTS3 table (with simple tokenizer). (the current code is in this db.c file in the init_db function http://github.com/boscowitch/wadoku-notify/blob/master/src/db.c ) now i wanted to ask if i precreate the indexed table into the db file how i can load/copy this table into a :memory: db without regeneratig the whole index. or can i advise sqlite to load at least the whole pre generated index into the ram to speed it up? if you are interested you can see an eary testing version without any indexing and ram tables in action here (now with FTS3 it instantly updates even if selection occurs very fast) http://www.youtube.com/watch?v=uhwp0XKX9U8 last but not least THANK YOU VERY MUCH! though sqlite and FTS3 i could make a very usefull app without reinventing the world. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
