[gdal-dev] SQL Server Driver

[Frank Warmerdam]

Jimmy,

>From an examination of MSSQLSpatialTableLayer::CreateFeature() it
appears a regular INSERT statement is done for each feature written to
the db rather than any sort of bulk mechanism.  I could be missing
something of course.  Hopefully Tamas will provide a more experienced
answer.

Best regards,
Frank


On Fri, Aug 24, 2012 at 3:03 PM, Duchesne, Jimmy <JDuchesne at korem.com> wrote:
> Hello,
>
>
>
> I’ve been using SQL Server Driver for a few days now, and I noticed it was
> very slow, whatever the parameters, such as GT, I was using.
>
>
>
> I need to insert millions of rows in a table.
>
>
>
> To give you an idea, it takes around 1 minute to import 10k records with the
> driver
>
>
>
> On the other hand, if I write my own routine which reads a MapInfo file and
> does batch insert into the database, I can insert over 125k records per
> minute.
>
>
>
> I tried reading the same TAB file with ogr2ogr but writing to PostGis and
> noticed the speed was about the same than my routine, which is enough for my
> needs.
>
>
>
> Would it be possible that the SQL Server Driver does not do bulk insert?
>
>
>
> Thanks for the help.
>
>
>
> Jimmy Duchesne
>
>
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev



-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Software Developer