OraFAQ Forum: Spatial » Updating a table with an SDO

Home » Server Options » Spatial » Updating a table with an SDO_GEOMETRY column (merged)

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

Updating a table with an SDO_GEOMETRY column (merged) [message #407312]

Tue, 09 June 2009 10:00

dyahav
Messages: 32
Registered: March 2009

Member

Hi all,

I have a table containing the following columns:
Id number primary key,
geom SDO_GEOMETRY

Firstly, I create the table and create the spatial index on the geom column.
Secondly, I insert 1 million rows into the table.

When I try to insert rows it performs very bad (around 12 seconds for 10,000 rows). For updates and deletes it performs worse.
This table should be available for users all the time and may be updated frequently.

Does anybody have an idea?
Thanks
dyahav

Report message to a moderator

Re: Updating a table with an SDO_GEOMETRY column [message #407313 is a reply to message #407312]

Tue, 09 June 2009 10:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>When I try to insert rows it performs very bad (around 12 seconds for 10,000 rows)

In very round numbers, 1000 rows per second or 1 millisecond per row.
It appears a bottleneck on the disk.
If so, better/faster hardware is only solution.

Report message to a moderator

Re: Updating a table with an SDO_GEOMETRY column [message #407321 is a reply to message #407313]

Tue, 09 June 2009 10:22

dyahav
Messages: 32
Registered: March 2009

Member

Hi,
I think it's not a bottleneck on the disk due to
the fact that executing without the spatial index
performs better (0.04 ms per row).

It seems that the problem is the spatial index but I have no
an alternative option.

Report message to a moderator

Previous Topic:	ORA-29902,ORA-13209 and ORA-06512
Next Topic:	storing gps values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 02:31:11 CST 2024