Re: [sqlite] Speed-Lost on using expression with combined "AND" and"OR"!

"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

Re: [sqlite] Speed-Lost on using expression with combined "AND" and "OR"!

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 ...

Re: [sqlite] Speed-Lost on using expression with combined "AND" and "OR"!

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

Re: [sqlite] Speed-Lost on using expression with combined "AND" and "OR"!

eral Discussion of SQLite 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 dr

Re: [sqlite] Speed-Lost on using expression with combined "AND" and "OR"!

"*System.Data.SQLite *is an enhanced version of the original SQLite 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

[sqlite] Speed-Lost on using expression with combined "AND" and "OR"!

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?