[GRASS-dev] Slow insert to GRASS SQLite db from QGIS

Vector import to GRASS in QGIS browser is very slow when using SQLite
database, about 6s/1000 features. It takes less than 1s with dbf
driver or if v.in.ogr + sqlite is used (even if run from GRASS tools).

The chain is: qgis.exe -> thread -> qgis.v.in.exe -> sqlite.exe

Could it be some SQLite db locking? Somehow switched on when
sqlite.exe driver is started from multi thread app? qgis.v.in.exe is
C++ MSVC. Any idea?

Radim

Solved. I forgot db_begin_transaction.
Sorry for noise.

Radim

On Mon, Jun 22, 2015 at 9:18 PM, Radim Blazek <radim.blazek@gmail.com> wrote:

Vector import to GRASS in QGIS browser is very slow when using SQLite
database, about 6s/1000 features. It takes less than 1s with dbf
driver or if v.in.ogr + sqlite is used (even if run from GRASS tools).

The chain is: qgis.exe -> thread -> qgis.v.in.exe -> sqlite.exe

Could it be some SQLite db locking? Somehow switched on when
sqlite.exe driver is started from multi thread app? qgis.v.in.exe is
C++ MSVC. Any idea?

Radim