[fdo-users] Re: IInsert and Property Values and Using Sequences
haris at sl-king.com
Fri Oct 15 04:42:31 EDT 2010
Have you tried FDO Batch Insert ? Should be much quicker.
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
More information about the fdo-users