Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
icon5.gif   logbook db size causing very slow response, posted by eric wooten on Tue Dec 31 17:56:34 2002 
    icon3.gif   Re: logbook db size causing very slow response, posted by Etienne Van Caillie on Sat Jan 4 17:55:49 2003 
       icon2.gif   Re: logbook db size causing very slow response, posted by Stefan Ritt on Sat Jan 4 20:07:20 2003 
    icon2.gif   Re: logbook db size causing very slow response, posted by Stefan Ritt on Thu Jan 9 10:25:10 2003 
    icon2.gif   Re: logbook db size causing very slow response, posted by Stefan Ritt on Sat Jan 11 18:09:04 2003 
Message ID: 193     Entry time: Sat Jan 11 18:09:04 2003     In reply to: 181
Icon: Reply  Author: Stefan Ritt  Author Email: stefan.ritt@psi.ch 
Category: Question  OS:   ELOG Version:  
Subject: Re: logbook db size causing very slow response 
> Was wondering if there were any tweaks/suggestions for improving the 
> logbooks responsiviness.  Our logbook was started 31 July 01.  Since that 
> time we have went from 1 logbook to 4 logbooks.  Logbook 1 having 2651 
> entries, logbook 2 having 300 entries, and the last 2 are new logbooks, so 
> only a few entries.

Another trick for large logbooks is to divide them into a logbook with 
recent entries and one with old entries (archive), like I did now in this 
forum. One can enable the "copy to" command for the administrator, who then 
can copy regularly old entries to the archive, keeping the recent logkook 
reasonable small with a good responsiviness. If one wants to search then the 
old messages, one can still go to the archive, but then the search command 
takes longer.
ELOG V3.1.5-2eba886