OraFAQ Forum: Spatial » spatial query in loop gets slower and slower

Home » Server Options » Spatial » spatial query in loop gets slower and slower

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

spatial query in loop gets slower and slower [message #75787]

Tue, 30 July 2002 02:40

Rohit Goel
Messages: 1
Registered: July 2002

Junior Member

Hi,
I have written a PLSQL procedure that runs spatial queries in a loop. Each query keeps getting slower and slower as number of executions increase. Can someone tell me why it is happening and how I can solve it ?
Thanks
Rohit

Report message to a moderator

Re: spatial query in loop gets slower and slower [message #75788 is a reply to message #75787]

Tue, 30 July 2002 02:58

Jens Vogelgesang
Messages: 23
Registered: January 2002

Junior Member

Can you please send the query. Do you use a primary or a secondary filter, or both??

Send a table escription and the spatail statement to the board.

Report message to a moderator

Re: spatial query in loop gets slower and slower [message #75791 is a reply to message #75788]

Tue, 17 September 2002 00:08

Ashaka Thakore
Messages: 1
Registered: September 2002

Junior Member

I referred to message on Oracle Spatial Message board as reply to Mr. Rohit titled "spatial query in loop gets slower and slower". I am also having the same problem as Mr. Rohit. I have indexed a table on geom field but if I execute the queries from other programs, it takes long time and it never executes.

Pl guide me.

Thank you.

Report message to a moderator

Previous Topic:	Creating a Spatial Index on LRS data fails
Next Topic:	convert geometric segments to LRS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 10:23:43 CDT 2025