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

2008-06-04 Thread Markus Wolters
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?

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

2008-06-04 Thread Markus Wolters
sqlite I think you can't get any help here ... -- [image: Just A Little Bit Of Geekness]http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E 6/1 Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. (Larry Wall). 2008/6/4 Markus Wolters [EMAIL PROTECTED