Opening the database takes a long time.

[DaveDavenport]

Starting GMPC (that uses glyr) it blocks for little over 2.5 seconds on glyr_db_init.
(compile gmpc with --enable-timings to see timestamps during startup).

-rw-r--r-- 1 qball qball 62M 2011-11-13 11:51 /home/qball/.cache/gmpc/metadata/metadata.db

[sahib]

Hello Dave,

Sorry for not being in the chat, im having a flu and some other problems right now.
The long startup time might be due VACUUM that is being performed on loading, or it might be the plain size of the db.
Probably the latter.. guess I have to offer an option to store only paths in the db.
I have very little time at the moment, therefore it might take some time to implement this.. sigh

Will be in #gmpc later the day.

[DaveDavenport]

don't do a vacuum on each startup, that is not going to speed things up.
See http://www.sqlite.org/lang_vacuum.html why it is so slow (it makes a complete copy off the db).
Large DB's are no problem, vacuuming each startup is!

[DaveDavenport]

Ok, I removed the VACUUM, this speeds up GMPC startup time. GMPC startup time is back to 160ms. (yes it was a > 15x increase in startup time.)

I think a 'cleanup' function that does it we trip periodically on shutdown would be nicer.

[sahib]

Okay, thanks for testing this. Will commit it later.