I've been working on the regression tests for the imminent release of 1.40.
Initially I was using SQLite3 since it has zero maintenance and zero setup
and the tests aren't all that strenuous (at least as far as the database is
concerned).
However, I found a stress run was taking 12 hours on a dual proc machine
with 2 GB of memory. That seemed rather outrageous so I tried with MySQL
and it dropped to an hour and a half.
Is SQLite3 really this bad? I can't imagine so or it wouldn't survive. In
that case, there must be something that we are doing or not doing in Bacula
or some problem in our build options that is killing the performance.
Is anyone out there using SQLite3? Does anyone have any suggestions on how
we could change the default build defines or database creation scripts to
improve the performance?
If there are any suggestions I'd appreciate getting them quickly so that we
can incorporate them into 1.40.
Thanks,
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
