Re: Slow Spatial Inserts

vmisetich_at_my-deja.com wrote:
>
> 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.
> >

Try bulk loading with the SQL*Loader utility (sqlldr)

--

Karl Johan Grøttum                                 tel:(+47) 776 29 406
Norut Information Technology Ltd.                  fax:(+47) 776 29 401
9291 Tromsø                       URL:   http://www.itek.norut.no/~karl

Norway                         E-mail: Karl.Johan.Grottum_at_itek.norut.no