Re: [Bacula-users] decoding lstat data

2009-04-16 Thread Kjetil Torgrim Homme
"Kelly, Brian" writes: > I've seen lots of posts regarding the decoding of Lstat data. I'm > currently using a few functions to decoded the lstat data and make > it human readable. These functions have been tested and are known > to work with mysql 5.0.70 hi, I spent quite a bit of work trying

Re: [Bacula-users] decoding lstat data

2009-04-15 Thread Craig Ringer
Kelly, Brian wrote: > If I run my example query against the backup with the largest volume of files > 163222 it takes 28 secs. So yeah, slow, but not slow enough to be a problem for how you use it, and not enough that you'd want to write a C extension instead. Good to know. It's probably worth p

Re: [Bacula-users] decoding lstat data

2009-04-15 Thread Kelly, Brian
: Re: [Bacula-users] decoding lstat data Kelly, Brian wrote: > I've seen lots of posts regarding the decoding of Lstat data. I'm currently > using a few functions to decoded the lstat data and make it human readable. > These functions have been tested and are known to wor

Re: [Bacula-users] decoding lstat data

2009-04-14 Thread Craig Ringer
Kelly, Brian wrote: > I've seen lots of posts regarding the decoding of Lstat data. I'm currently > using a few functions to decoded the lstat data and make it human readable. > These functions have been tested and are known to work with mysql 5.0.70 > CREATE FUNCTION MYBASE64_DECODE (input BLOB)