[Digikam-devel] extragear/graphics/digikam/libs/database

[Marcel Wiesweg]

> Ok one last note here: In the link above it is explained quite well I
> think. So LEFT JOIN can generate performance issues, especially when used
> nested. The thread also is talking about the EXPLAIN command, which I was
> talking about before.
> It is used to see which instructions SQL is doing behind the scenes.
> LEFT JOINs will mostly generate more instructions, and sometimes
> performance loss is really visible (someone mentioned in the link that he
> dropped execution time from 600ms to 20ms or 30ms, which is quite good).

Ok following this we can probably change quite a few "LEFT JOIN"s in our SQL 
into "JOIN"s.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20090529/4510e5d8/attachment.html>