On Sun, Nov 21, 2010 at 7:49 PM, boscowitch li...@boscowitch.de wrote:
or can i advise sqlite to load at least the whole pre generated index
into the ram to speed it up?
http://www.sqlite.org/backup.html
--
D. Richard Hipp
d...@sqlite.org
___
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
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
Am Montag, den 22.11.2010, 01:24 + schrieb Simon Slavin:
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