Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow Spatial Inserts
Sorry folks, I should also mention that I'm running Oracle 8i on
Windows NT 4.0. Sorry about not specifying that in my original post.
> Hello!
>
> I'm trying to insert rows into a spatial table, and it's taking an
> extremely long time -- several minutes per row. Here is the structure
> of the table:
>
> Destination Table: ServiceArea (31268 rows)
> SERVICEAREAID NUMBER(10)
> SERVICEPROVIDERID NUMBER(10)
> SERVICETYPEID NUMBER(10)
> DESCRIPTION VARCHAR2(254)
> PRINX NUMBER
> GEOLOC SDO_GEOMETRY
> CREATEDATETIME DATE
> POLYGONSOURCEID NUMBER(10)
>
> A typical insert statement would look something like this:
> INSERT INTO "ODW_OWNER"."SERVICEAREA"
>
("SERVICEAREAID", "SERVICEPROVIDERID", "SERVICETYPEID", "DESCRIPTION", "
> PRINX", "CREATEDATETIME", "POLYGONSOURCEID", "GEOLOC") VALUES (83000,
> 15519, 102, 'Continental US polygon for Sprint long distance.', 0,
> sysdate, 0, <sdo_geometry object goes here.>)
>
> I can get my inserts to work, but, as I mentioned above, they take
> forever. Has anyone experienced a similar slowness in inserting into
> spatial tables? If so, what can I do to help speed things up? Any
> suggestions would be helpful and greatly appreciated.
>
> Thanks,
> Vince
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jan 21 2000 - 15:56:31 CST