Re: [sqlite] EXT :Re: Re Query planner creating a slow plan

2012-04-27 Thread Peter
Black, Michael (IS) wrote, On 26/04/12 22:40: I must be blind (something my wife would agree with)...but I did use "order by transfer_date"the "asc" making no difference. Not at all. What you posted was the slow plan. The three queries that show the planner's behaviour are: 1) sqlite>

Re: [sqlite] EXT :Re: Re Query planner creating a slow plan

2012-04-26 Thread Black, Michael (IS)
e.org] on behalf of Peter [pe...@somborneshetlands.co.uk] Sent: Thursday, April 26, 2012 3:57 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Re Query planner creating a slow plan Black, Michael (IS) wrote, On 26/04/12 21:39: > My fault...I thought I had extracted it und