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

re 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

[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?