Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
icon5.gif   SQL Database, posted by lance on Thu Sep 2 10:30:14 2010 
    icon2.gif   Re: SQL Database, posted by Stefan Ritt on Wed Sep 15 00:21:10 2010 
    icon2.gif   Re: SQL Database, posted by Bill Pier on Thu Sep 23 17:22:43 2010 
Message ID: 66915     Entry time: Thu Sep 23 17:22:43 2010     In reply to: 66886
Icon: Reply  Author: Bill Pier  Author Email: bpier@clove.org 
Category: Question  OS: Windows  ELOG Version: 2.7.6-2230 
Subject: Re: SQL Database 

What about using something like MySQLfs to get a db backend transparently to ELOG?  I use ENCFS, (a FUSE backend), currently to achieve encrypted logbooks and it works fine -- ELOG never knows anything other than reading and writing to logbook files.  From what I've read, the MySQLfs backend would work the same, and you likely would gain some of the caching benefits of MySQL, which might help with your read/search times, given the memory requirements of the database of course.

 

Bill

lance wrote:

We have been running elog for a few years now and its solid. The only thing is we are getting to 140k entries over a few books and its starting to slow down whist searching. My questions is can we go to an SQL type database rather than a flat file? Is it worth it? Is anyone running this type of configuration?

 

 

ELOG V3.1.5-fe60aaf