Ticket #1626 (new enhancement)

Opened 1 year ago

Last modified 1 year ago

Poor performance of MySQL CreateFeature()

Reported by: Kosta Assigned to: warmerdam
Priority: normal Milestone:
Component: OGR_SF Version:
Severity: normal Keywords: MySQL CreateFeature
Cc: hobu

Description

I get really poor performance if I add features to an MySQL layer or do a complete CopyLayer?() operation into an MySQL data source.

The tests were performed on an MySQL server running on the local machine (localhost; Win XP). The average performance for adding new features is about 40 features per second (for comparision: if I add the same layers to shapefiles, I get about 1000 features per second)

  • Is this the expected performance for the MySQL driver?
  • Are there any chances to speed this operation up?
  • Are there any performance tests done for the different OGR drivers?

Change History

05/10/07 09:48:20 changed by warmerdam

  • keywords set to mysql.
  • cc set to hobu.

Kosta,

I suspect the poor performance relates to the cost of doing a full committed transaction for each feature. For other RDBMS drivers we have tried aggregating many feature creations into a single transaction and commit to speed things up. Adding Howard as a cc in case he has some comment.

05/16/07 07:05:53 changed by Kosta

  • keywords changed from mysql to MySQL CreateFeature.

See also RFC #13 and ticket #1633