On Friday 01 September 2006 00:51, Marco wrote: > Just an idea: > > I did not build v1.38.11 and v1.38.8 myself but installed the debian > packages. During the downgrade I noticed that there were changes concerning > sqlite and sqlite3. I have not take a closer look on this because I don't > understand much about it anyway. But maybe you could check whether the > package maintainer's work caused the problem.
Well, if you switched from using SQLite to using SQLite3 then you would see exactly this kind of slow down. I have found that SQLite3 is *much* slower because the default way it handles writing to the database is very different. Some of the speed reduction can be fixed by properly configuring is, which is done automatically in the database creation scripts, but during an upgrade, it is unlikely these changes to the default SQLite3 behavior would be made. I think you have found the source of the problem. You have several choices: 1. Switch to MySQL, which is much faster (possibly PostgreSQL, but it is slower than MySQL). 2. Keep using SQLite version 2 3. Take a look at the 1.38.11 make_sqlite3_tables scripts for the optimization modifications and apply them to your database. It will still probably run much slower than SQLite version 2. > > /m > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
