Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)
2009-06-18 20:04:40
>
> 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
)
------------------------------------------------------------------------------
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
|
|
|