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: 191     Entry time: Thu Jan 9 10:25:10 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.

In Version 2.2.5, the responsiviness to large (>1000 entries) logbooks has 
been improved dramatically. If no filtering is applied, a page from the 
logbook listing should be displayed with a response time independent of the 
logbook size (I tried 8000 entries). Only when a filter or sort option is 
applied, all entries have to be searched which takes ~5sec for 8000 entries 
on a 1.2 GHz Windows XP Laptop, which is the same speed as before.
ELOG V3.1.5-fe60aaf