[gdal-dev] mssql import speed

[Tamas Szekeres]

Hi Martin,

Try to check in the SQL profiler that the BCP was successfully enabled and
not plain insert statements are executed. (ie. the BCP enabled plugin was
loaded)
If BCP was enabled you might also try to load data on the server machine,
so the network doesn't limit the bandwidth.

Otherwise we don't seem to have more options.

Best regards,

Tamas


2018-05-10 19:18 GMT+02:00 Martin Landa <landa.martin at gmail.com>:

> Hi,
>
> I wonder how to speed up import to MSSQL. I have testing SQLite DB
> (~1GB) with 48 tables (overall number of records 11e6). I started with
>
> $ ogr2ogr -f MSSQLSpatial MSSQL:... test.db
>
> It took more than 3hours! Tested on Windows computer with SQL Server
> 2012. I used SQL Server Native Client 11.0.
>
> So I tried to enable BCP (which should be enable anyway) and increased its
> size:
>
> $ ogr2ogr -f MSSQLSpatial MSSQL:... --config MSSQLSPATIAL_USE_BCP YES
> --config MSSQLSPATIAL_BCP_SIZE 10000 test.db
>
> No difference, more than 3 hours. Anything I could miss?  It's my
> first experience with MSSQL. Anything related to configuration or so?
> Thanks for pointers in advance! Martin
>
> --
> Martin Landa
> http://geo.fsv.cvut.cz/gwiki/Landa
> http://gismentors.cz/mentors/landa
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20180510/8875741d/attachment.html>