Hi Markus, http://www.sqlite.org/optoverview.html may help...
>From earlier performance discussions, ORs can prevent indices being used - do your tables have indices? Try "EXPLAIN QUERY PLAN " preceding your SELECTs to determine whether indices are being used. Rgds, Simon 2008/6/4 Markus Wolters <[EMAIL PROTECTED]>: > Hi, > > > > I've got a problem in combining expressions. On combining multiple ANDs with > an OR within a SELECT WHERE clause, SQLite takes years to respond. (Database > has a size of only about 1 MB). > > Using two SELECTs and combining them by UNION works like a charm! What could > be the problem here? > > > > This statement takes about 10 seconds after result can be read: > > > > SELECT <.> FROM Scenes AS s, Movies AS m, Categories AS c WHERE m.Id = > s.MovieId AND ((s.MovieId = c.MovieId AND s.SceneNo = c.SceneNo AND > c.CategorieId IN (60)) OR Rating IN (2)) > > > > Working statement (immediate response): > > > > SELECT <.> FROM Scenes AS s, Movies AS m, Categories AS c WHERE m.Id = > s.MovieId AND s.MovieId = c.MovieId AND s.SceneNo = c.SceneNo AND > c.CategorieId IN (410) > > UNION > > SELECT <.> FROM Scenes AS s, Movies AS m WHERE m.Id = s.MovieId AND s.Rating > IN(1) > > > > I am using System.Data.SQLite from http://sqlite.phxsoftware.com/ > > > > Thanks for any response! > > > > Regards, > > Markus > > > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
