[Digikam-devel] [Bug 160966] some searches don't work properly with the new sqlite3-3.5.8

[Arnd Baecker]

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
         
http://bugs.kde.org/show_bug.cgi?id=160966         
arnd.baecker web de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
      everconfirmed|0                           |1



------- Additional Comments From arnd.baecker web de  2008-04-26 13:56 -------
Using Andi's query from #c26 and his database, I can reproduce the
problem with sqlite 3.5.8:

date
sqlite3 andi_digikam3.db
SELECT Images.id, Images.name, Images.dirid, Images.datetime, Albums.url FROM Images, Albums LEFT JOIN ImageProperties ON Images.id = Imageproperties.imageid WHERE (  (ImageProperties.value >= '5' and ImageProperties.property='Rating')  )  AND (Albums.id=Images.dirid);
.quit
date

this takes between 10-15s on my machine while with sqlite 3.3.8 it
is way below 1s.
I will try to contact the people from sqlite3.

Andi, again thanks a lot for your work ...

Arnd