Poor performance of MySQL CreateFeature()

[Kosta]

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?

[warmerdam]

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.

[Kosta]

See also RFC #13 and ticket #1633

[Jukka Rahkonen]

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.

[Kosta]

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.