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 did this three times and
then did the CONVERT() version three times.
Averages:
CAST: 62 seconds
CONVERT: 58 seconds
Obviously the CAST() version is preferable though, in practice, I
don't know if you'd be able to tell the difference without a stopwatch.
Yeah, that makes a lot of sense. Sorry, I swapped the figures. CAST
average was 58 seconds, CONVERT was 62
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
