Home » Server Options » Spatial » Updating a table with an SDO_GEOMETRY column (merged)
Updating a table with an SDO_GEOMETRY column (merged) [message #407312] Tue, 09 June 2009 10:00 Go to next message
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




Re: Updating a table with an SDO_GEOMETRY column [message #407313 is a reply to message #407312] Tue, 09 June 2009 10:04 Go to previous messageGo to next message
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.
Re: Updating a table with an SDO_GEOMETRY column [message #407321 is a reply to message #407313] Tue, 09 June 2009 10:22 Go to previous message
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.
Previous Topic: ORA-29902,ORA-13209 and ORA-06512
Next Topic: storing gps values
Goto Forum:
  


Current Time: Thu Mar 28 03:34:06 CDT 2024