Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)
2009-06-19 03:44:13
Subject: |
Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang) |
From: |
Tom Sommer <mail AT tomsommer DOT dk> |
To: |
Jari Fredriksson <jarif AT iki DOT fi> |
Date: |
Fri, 19 Jun 2009 09:40:04 +0200 |
Jari Fredriksson wrote:
>> INSERT INTO Filename( Name )
>> SELECT a.Name
>> FROM (
>>
>> SELECT DISTINCT Name
>> FROM batch
>> ) AS a
>> WHERE NOT
>> EXISTS (
>>
>> SELECT Name
>> FROM Filename AS f
>> WHERE f.Name = a.Name
>> )
>>
>>
>
> That looks silly.
>
> I would write it shorter as
>
> INSERT INTO Filename(Name)
> SELECT DISTINCT Name
> FROM batch AS a
> WHERE NOT EXISTS
> (
> SELECT Name
> FROM Filename AS f
> WHERE f.Name = a.Name
> )
Make a bug report :)
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|