Re: [sqlite] Optimising a query with several criteria

2011-03-13 Thread Black, Michael (IS)
mroth.com] Sent: Sunday, March 13, 2011 8:40 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Optimising a query with several criteria Hi Michael, thanks for this. My database is 40 megabytes (and growing slowly) - is that a reasonable cachesize? On 13/03/2011 13:07, Bla

Re: [sqlite] Optimising a query with several criteria

2011-03-13 Thread Simon Slavin
On 13 Mar 2011, at 11:43am, Ian Hardingham wrote: > SELECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM > multiturnTable WHERE player1 ='?' UNION ALL SELECT rowid FROM > multiturnTable WHERE player2 = '?') AND (complete=0 OR p1SubmitScore=0 > OR p2SubmitScore=0) AND p1Declined=0 AND

Re: [sqlite] Optimising a query with several criteria

2011-03-13 Thread Ian Hardingham
; Sent: Sunday, March 13, 2011 6:43 AM > To: General Discussion of SQLite Database > Subject: EXT :[sqlite] Optimising a query with several criteria > > Hey guys. > > I've optimised most of my queries to work effectively, but I have one > which is sometimes causing me problems.

Re: [sqlite] Optimising a query with several criteria

2011-03-13 Thread Black, Michael (IS)
@omroth.com] Sent: Sunday, March 13, 2011 6:43 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] Optimising a query with several criteria Hey guys. I've optimised most of my queries to work effectively, but I have one which is sometimes causing me problems. It is: SELECT * FROM

[sqlite] Optimising a query with several criteria

2011-03-13 Thread Ian Hardingham
Hey guys. I've optimised most of my queries to work effectively, but I have one which is sometimes causing me problems. It is: SELECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM multiturnTable WHERE player1 ='?' UNION ALL SELECT rowid FROM multiturnTable WHERE player2 = '?') AND (