"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
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
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
"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
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
5 matches
Mail list logo