Re: [gdal-dev] very slow sql ogr2ogr conversion

2021-04-28 Thread Neil Walker
quot;MSSQLSPATIAL_BCP_SIZE" > > Another thing I found useful was to check the SSMS Profiler to see what's > going on as you run. > > Finally, I was forced by circumstances to use SQL Server, but if that's > not your case, I strongly recommend you to get away from it :) > >

Re: [gdal-dev] very slow sql ogr2ogr conversion

2021-04-28 Thread Neil Walker
recommend you to get away from it :) > > Hope this helps, > > Hector > > > On Tue, 27 Apr 2021, 19:47 Neil Walker, > wrote: > >> Hello, >> >> First time user, I hope this is the right mailing list :) >> >> >> >> I have a fairl

[gdal-dev] very slow sql ogr2ogr conversion

2021-04-27 Thread Neil Walker
Hello, First time user, I hope this is the right mailing list :) I have a fairly small (37mb - 160,000 linestrings) shp file and it loads into QGIS in a couple of seconds. I want to import this into sql server, so used the following ogr2ogr command: ogr2ogr -f "MSSQLSpatial"