Performance issues - feature insert via feature dao an content values

[pab2d]

Hi,

using GeoPackage, i recognizes that the insert perfomance is far slower than my privious SpatiaLite implementation with a bulk insert.

privious:
my BulkInsert class creates a sql string with an insert command and all content values..

private BulkInsert(String tableName, ContentValues cv) throws Exception {
	this.db = getDBReadWrite();
	this.db.exec("BEGIN TRANSACTION", null);
	this.stmt = prepareInsertStatement(db, tableName, cv, true);
}

Inside the prepareInsertStatement methode the function: ST_GeomFromWBK is used to handle the geometry column

BulkInsert bi=null;
...
long id=bi.execute(cv);

current (GeoPackage):

FeatureDao featureDao = gpkg.getFeatureDao(tableName);
rowCount = featureDao.insert(cv);

Is there a way to increase the insert performance?

[bosborn]

Try performing inserts in chunked transactions.

geopackage-android/geopackage-sdk/src/main/java/mil/nga/geopackage/user/UserDao.java

Lines 116 to 146 in 3679d01

	/**
	* {@inheritDoc}
	*/
	@Override
	public void beginTransaction() {
	db.beginTransaction();
	}
	/**
	* {@inheritDoc}
	*/
	@Override
	public void endTransaction(boolean successful) {
	db.endTransaction(successful);
	}
	/**
	* {@inheritDoc}
	*/
	@Override
	public void commit() {
	endAndBeginTransaction();
	}
	/**
	* {@inheritDoc}
	*/
	@Override
	public boolean inTransaction() {
	return db.inTransaction();
	}

See Example Tests:

• Performance Test on Feature Inserts
• Transaction Tests

[pab2d]

Thank you bosborn