Re: Spatial query tuning...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Fri, 19 Nov 2004 10:29:32 +0100
Message-ID: <cnkeds$n0u$1@nntp.fujitsu-siemens.com>

"Jan" <janik_at_pobox.sk> schrieb im Newsbeitrag news:81511301.0411180051.2c7cf03a_at_posting.google.com...
> "A substantial number of insert and delete operations affecting an R-tree index may
> degrade the quality of the R-tree structure, which may adversely affect query
> performance."

I built the indexes after the inserts. Btw, the query took 5 hours. Anyway, I solved the problem by separately entering the coordinates of the bounding boxes and filtering likely candidates first. Got down to 20s without any additional indexes. Will try further indexing today.

Thanks anyway!
Volker Received on Fri Nov 19 2004 - 03:29:32 CST