On 8/26/06, P Kishor <[EMAIL PROTECTED]> wrote:
On 8/26/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
> Instead of indexing each column on its own, try making them one big index.
>
Thanks. Actually making a composite index really helped. The match
rate went from 2.5/sec to more than 82/sec. Very nice. I did the
following --
sqlite> CREATE INDEX ix_polys ON polys (xmin, ymin, xmax, ymax);
sqlite> CREATE INDEX ix_points ON points (x, y);
I spoke too soon. Looping through 500 points completed in 8 seconds.
But looping through 5000 points too 1330 seconds. My enthusiasm was
premature.
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
