On 18 Jan 2006 at 16:05, Kern Sibbald wrote: > On Wednesday 18 January 2006 15:17, Dan Langille wrote: > > On 18 Jan 2006 at 14:50, Kern Sibbald wrote: > > > 2. It updates the database File records in one SQL statement rather than > > > two. > > > > Wow! I've been thinking about that one lately. A big reason for > > upgrading. Now, if only you could give me the time to do it. > > Well, with everything else that is going on, it probably doesn't make any big > percentage overall difference. > > However, I do have some new ideas on how to use transactions, which could > make > some pretty big differences. Now, if only you could give me the time to do > it. :-)
Using transactions will speed things up tremendously. I speak only for PostgreSQL. But at the moment, a flush to disk happens after every write. With transactions, such things will be queued and occur only as needed/required. -- Dan Langille : http://www.langille.org/ BSDCan - The Technical BSD Conference - http://www.bsdcan.org/ ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
