В сообщении от Friday 13 June 2008 20:38:42 Andrew Brampton написал(а):
> Hi Donald,
>
> I have a index on both lat and long, but please correct me if I'm wrong,
> but I think SQLite will only use a single index per SELECT. So only one of
> the index is in use. I think the EXPLAIN command confirms
Hi Noël,
Sorry I wasn't clear... I don't have a windows compiler, hence being unable
to compile it :)
Andrew
- Original Message -
From: "noel frankinet" <[EMAIL PROTECTED]>
> However at the moment I'm unable to compile it, so I was wondering if
> anyone had a DLL for windows which I
125467816 AND latitude < 64.6631165643883
ORDER BY zoom
LIMIT 50;
- Original Message -
From: "Griggs, Donald" <[EMAIL PROTECTED]>
Sent: Friday, June 13, 2008 5:15 PM
Subject: Re: [sqlite] rtree extension - Windows Binary?
> Hi Andrew,
>
> Maybe this go
Griggs, Donald a écrit :
> Hi Andrew,
>
> Maybe this goes without saying, but I guess you've already worked on the
> "usual suspects" such as:
>
> -- An index for Lat and another for Lon.
> -- Larger cache
> -- EXPLAIN QUERY PLAN prefix to ensure that index used
> -- One-time VACUUM has any
Hi Andrew,
Maybe this goes without saying, but I guess you've already worked on the
"usual suspects" such as:
-- An index for Lat and another for Lon.
-- Larger cache
-- EXPLAIN QUERY PLAN prefix to ensure that index used
-- One-time VACUUM has any effect?
-- ANALYZE
-Original
5 matches
Mail list logo