Hi,

 

 

which SQLite writer are you using? There are 3:

 

 

SQLite non-spatial

 

SQLite spatial (FDO)

 

SpatiaLite

 

 

If you need geometries, consider trying the SpatiaLite writer.

 

 

David

---

Hi David and thanks for the quick response.

 

 

I am using SQLite spatial (FDO). I've tried the SpatiaLite with good result, but I cant connect my SQLite-database in Autocad Map.

 

 

//Johan 

---

It is unfortunately the nature of the beast; a proper database implementation will almost always have worse performance than a Shapefile.

 

 

I believe FDO is a middle layer (a bit like ArcSDE) and it might also slow things down a little bit.

 

 

Make sure that you're writing to a local directory and not a network share.

 

 

Also check if you've defined an index on one or more columns, if so try to disable them and see if it improves the write speed.

 

 

David

---