"*System.Data.SQLite *is an enhanced version of the original SQLite <http://www.sqlite.org/>database engine. It is a complete drop-in replacement for the original sqlite3.dll"
If you don't use original sqlite I think you can't get any help here ... -- [image: Just A Little Bit Of Geekness]<http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1> Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. (Larry Wall). 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
