Information about optimisation of lire for bigger log file

[Francis J. Lacoste]

On Sat, 2003-10-25 at 14:14, Jama Poulsen wrote: 
> On Sat, Oct 25, 2003 at 11:32:57AM -0400, Francis J. Lacoste wrote:
> > The current Lire CVS, which should come out as Lire 1.4 beta in the
> > coming days, uses a SQLite database for the storage of the DLF data and
> > generates the report using SQL statements on that storage.
> 
> This SQL based storage/analysis functionality is great news.
> 
> Will this functionality be made database independent using Perl DBI
> at some 

It is built using DBI, but making it database independant probably won't
happen for two reasons :

- The semantics of the Lire Report Specification Language are different
than what you find in SQL92. SQLite allows us to define extensions
functions which we use to implement most of the aggregators (and some of
the aggregate operators). Supporting other database would mean to
develop such extension functions for each database we would want to
support.

- SQLite is very portable and fast. I would doubt that supporting other
databases would add much benefit over using SQLite. 

If people aren't interested in the reporting facility of Lire, it would
be easier to support storage of the DLF into any DBI supported DBMS. 
The users would then have to use other SQL-based reporting facility to
generate reports.

> I have two questions regarding Lire functionality on the client-side:
> 
> - What is the status/progress on client-side 'raw-log to DLF-log
>   processing', to reduce the server load? This should preferably
>   be possible with a stripped down Lire package with much fewer
>   dependencies.

This isn't an item currently planned. The requirements would be the
same than for a text-only installation.

> - Will it in the future be possible to let the client also submit
>   the customised report layout (eg. a www.cfg file) to a remote Lire
>   server together with the (Raw/DLF) log-data? Including perhaps the
>   whole $HOME/.lire directory. The idea is to give clients control over
>   the reporting process (perhaps with some access/resource restrictions).

Altough nothing of the sort is currently scheduled, the idea was to offer
that kind of functionality over a web interface rather than by email. 

> 
> I'll be installing Lire v1.4 and its dependencies from source again
> on Solaris. I'll post my results.

Thanks for your help!
 
Kind regards,

Francis J. Lacoste

-- 
Francis J. Lacoste              . .           http://www.logreport.org
/^LogReport$/               . .               flacoste at logreport.org

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.logreport.org/pipermail/questions/attachments/20031027/88903dcf/attachment.bin