On 22 Nov 2010, at 12:49am, boscowitch wrote: > 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.
This may seem silly, but are you absolutely sure you need to load the database into memory ? I've seen some apps which to go great lengths to do this but hardly slow down at all just accessing the database from disk. If you take the memory you were storing the database in, and use if for disk caching instead you can get pretty good speeds just using FTS3 as intended. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
