Saturday, April 25, 2009

Item Assistant Speedup

Ripping the AODB in Item Assistant have been greatly sped up in a recent subversion commit (#310) bringing the time it takes to rip the AODB down from 2:42 to about 1:25 (on my setup). Users with SSD drives are probably not getting a big boost, but you are all spoiled anyway :P

The code change simply tell SQLite to use a memory based journal while ripping, instead of the default file based journal by running the following command on the database:

PRAGMA journal_mode=MEMORY

The program is now probably using more memory while ripping, but since most people can spare 50-100 MB I don't think it will be a problem.