[gdal-dev] Writing to SQLite is very slow

[Roald de Wit]

Hi list,

Whilst trying to mimic ogr2ogr functionality in Python, I stumbled upon 
an issue with writing to SQLite: it works, but it's painfully slow 
(minutes instead of seconds).

The link below points to an example that can be used for reproducing the 
behaviour:
http://rdewit.pastebin.com/f73c9b3c0

Outputting to ESRI Shapefile, or another CSV is very fast. It's only 
SQLite that seems to be slow.

Any idea what I'm doing wrong?

Regards, Roald