Opened 17 years ago

Closed 9 years ago

#1626 closed enhancement (fixed)

Poor performance of MySQL CreateFeature()

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


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 (5)

comment:1 by warmerdam, 17 years ago

Cc: hobu added
Keywords: mysql added


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.

comment:2 by Kosta, 17 years ago

Keywords: MySQL CreateFeature added; mysql removed

See also RFC #13 and ticket #1633

comment:3 by Jukka Rahkonen, 9 years ago

Can anybody say if this ticket is still valid? Insert rate of 40 features per second is so slow that if would be odd if MySQL users would have tolerated it for the past 8 years.

comment:4 by Kosta, 9 years ago

Since I don't use MySQL (anymore) I cannot comment on this...

I am fine with closing this old ticket now because I guess it is completely outdated now.

comment:5 by Jukka Rahkonen, 9 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.