Re: [sqlite] Performance query with many joins

2006-07-04 Thread drh
"Richard Hartland" <[EMAIL PROTECTED]> wrote: > The +asc in the order by is not being recognized as correct syntax. I am > unfamiliar with using the + operator in this way - what does it do? > > > I'm guessing it might go faster if you (1) run ANALYZE first or > (2) record the ORDER BY clause to

Re: [sqlite] Performance query with many joins

2006-07-04 Thread Nemanja Corlija
On 7/4/06, Richard Hartland <[EMAIL PROTECTED]> wrote: The +asc in the order by is not being recognized as correct syntax. I am unfamiliar with using the + operator in this way - what does it do? I guess drh made a typo in his previous email. That order by should probably be something like: OR

RE: [sqlite] Performance query with many joins

2006-07-04 Thread Richard Hartland
ssage- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 July 2006 09:04 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Performance query with many joins "Development" <[EMAIL PROTECTED]> wrote: > > This table gets filled in a random order with the SortID

Re: [sqlite] Performance query with many joins

2006-07-04 Thread drh
"Development" <[EMAIL PROTECTED]> wrote: > > This table gets filled in a random order with the SortID being generated = > on load. The Select query then changes slightly to enforce this order: > > SELECT > T1.TheID, > T1.Column1, > T1.Column6, > T2.Column2, > T2.Colu

[sqlite] Performance query with many joins

2006-07-03 Thread Development
Hi, I have been using SQLite for a while now and I have been getting very good performance. However, recently I have been stumped by the poor performance of a particular query. I wonder if anyone out there can shed any light on the matter for me. I have a database with a number of tables (N) wi