[fdo-users] Re: IInsert and Property Values and Using Sequences Question

[Haris Kurtagic]

Have you tried FDO Batch Insert ? Should be much quicker.
Haris

On Fri, Oct 15, 2010 at 10:39 AM, Crispin_at_1Spatial
<crispin.hoult at 1spatial.com> wrote:
>
> I started with KingOra (am working in Map 2010 so have options) and found two
> other differences
>
>  1) KingOra did not require the table to have primary keys set before
> insert.  This negated the need for a sequence at all as I was quite happy to
> have no PKey in my staging area.  Autodesk.Oracle requires PKey and hence I
> needed to change the DB schema and hence the current problem.
>
> So why did I not stay with KingOra?
>
>  2) StartTransaction() is not yet enabled in KingOra so writing 1000 objects
> with IInsert was taking a minute or so.  Using Autodesk.Oracle and
> transactions means it is 1-2 seconds.
>
> --
> View this message in context: http://osgeo-org.1803224.n2.nabble.com/IInsert-and-Property-Values-and-Using-Sequences-Question-tp5635940p5638089.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>