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?
*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
Database
Betreff: Re: [sqlite] Speed-Lost on using expression with combined
AND and OR!
*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
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
2008/6/4 Markus Wolters [EMAIL PROTECTED]:
Well why not? They've just integrated the ADO.NET provider into the DLL.
It IS SQLITE...
I have just quote what they write: It is a complete drop-in replacement for
the original sqlite3.dll I don't know what they rewrite and how ...
Markus Wolters [EMAIL PROTECTED] wrote
in message news:[EMAIL PROTECTED]
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