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 times as long to complete.
Cheers,
Troy.
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) = 'makedev';
+---------+
| Name |
+---------+
| MAKEDEV |
+---------+
1 row in set (1.15 sec)
So I dont understand why it wouldn't work in the other query - but I'm
not a MySQL Guru.
I am running MySQL Server 3.23.58 tho which could be the difference I
suppose.
Cheers,
Troy.
Cedric Tefft wrote:
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.ClientId
AND JobStatus='T' AND Job.JobId=File.JobId
AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
AND LCASE(Filename.Name)='filenameinlowercase.doc'
ORDER BY Job.StartTime LIMIT 20;
Have you actually tried this? It didn't work for me. I suspect this
is because LCASE is designed to operate on text fields and, as Mark
pointed out, the Name field is defined as a binary object.
- Cedric
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
