Very slow startup with CCDB sqlite file

[DraTeots]

Mark Dalton recently told me of an issue with hd_root taking several minutes to start
processing events when running on the gluons. After a little investigation, I was able
to reproduce the problem in my own account, but only if using an sqlite file for CCDB.
If I use mysql, then it starts up normally in just a few seconds.

Has anyone else observed this recently? I have successfully used sqlite for CCDB
quite a bit so I'm suspicious this is not a global issue but wanted to check with others
before fully escalating it to defcon Romanov.

-David

https://groups.google.com/forum/#!topic/gluex-software/stOBsyHJsoE

[sdobbs]

Anecdotally, I am seeing a noticable performance hit when running with a CCDB SQLite file instead of using a MySQL version. Naively, I'm not sure why this would be the case since I don't think that there are any CCDB calls in sim-recon right now when processing events, just during initialization/begin of run. Any ideas on how I can try to track this down?