[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] Alternative DB proposal


Hello John,

An other solution that doesn't require any additional code and no database 
structure modification, is to use a PL function to extract mtime, ctime, 
size, block_size etc... from LStat field.

This function is available on Postgresql and now on Mysql (thanks to Kjetil). 

The only drawback that i see with this PL function, is that you *should* avoid 
to use it in WHERE or JOIN clauses. But, it works very well for reporting and 
analysis.

Bye

Le Tuesday 07 October 2008 04:50:50 John Huttley, vous avez écrit :
> Hi
> My first test are complete.
> To aid in getting all the questions/answers and results in one place,
> I've made a wiki entry.
>
>
> http://wiki.bacula.org/doku.php?id=wiki:playground
>
>
> My scripts are attached.
>
> --John



-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.