Cedric Tefft wrote:
Robert Nelson wrote:
You can also try "select Name from Filename where CAST(Name AS CHAR) =
'makedev';".
On my machine it was somewhat faster than CONVERT.
Out of curiosity, I plugged the CAST() function in to query.sql and
ran a real bacula search for 'makedev'. I
Robert Nelson wrote:
You can also try "select Name from Filename where CAST(Name AS CHAR) =
'makedev';".
On my machine it was somewhat faster than CONVERT.
Out of curiosity, I plugged the CAST() function in to query.sql and ran
a real bacula search for 'makedev'. I did this three times and
AM
To: Troy Daniels
Cc: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] case insensitive query
Troy Daniels wrote:
> An update to this.
>
> I cant vouch for this exact query - on my system it takes a looonnggg
> time to finish due to the 2 million plus files recorded
Troy Daniels wrote:
An update to this.
I cant vouch for this exact query - on my system it takes a looonnggg
time to finish due to the 2 million plus files recorded and I gave up
and canceled it, but the following simplified version worked:
mysql> select Name from Filename where LCASE(Name)
An update to my update - I ran my query against a smaller bacula db
(Only just over 700k files in this one) and after 5m 38s of waiting it
returned a case insensitive matching list of files.
Without the LCASE() function it took 1m 49s for the same query to be
performed.
So thats just over 3
An update to this.
I cant vouch for this exact query - on my system it takes a looonnggg
time to finish due to the 2 million plus files recorded and I gave up
and canceled it, but the following simplified version worked:
mysql> select Name from Filename where LCASE(Name) = 'makedev';
+---
Doh! I have to admit a failure to test this particular query.
I've used the technique on other queries tho and just applied it to this
scenario.
I completely missed the reference to the filename field being binary too
- too much work, not enough time!
My bad! Sorry!
Troy.
Cedric Tefft wr
Troy Daniels wrote:
Under MySQL you can use the LCASE() (Or UCASE if you prefer) function
to do something like:
SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.C
Mark Nienberg wrote:
I'm using Bacula to back up a Linux Samba fileserver among other
machines. Of course the clients to the fileserver are windows
machines and they don't care about case in filenames. They create all
sorts of case combinations like "document1.doc", "Document2.DOC" and
so o
Under MySQL you can use the LCASE() (Or UCASE if you prefer) function to
do something like:
SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
AND JobStatus
Mark Nienberg wrote:
I'm using Bacula to back up a Linux Samba fileserver among other
machines. Of course the clients to the fileserver are windows machines
and they don't care about case in filenames. They create all sorts of
case combinations like "document1.doc", "Document2.DOC" and so on.
I'm using Bacula to back up a Linux Samba fileserver among other
machines. Of course the clients to the fileserver are windows machines
and they don't care about case in filenames. They create all sorts of
case combinations like "document1.doc", "Document2.DOC" and so on.
My most common rest
12 matches
Mail list logo
