We have noticed a clear increase in the time it takes to create (that the time it takes to save) a post in wordpress as the number of posts gets larger. The degradation in performance is substantial and quite noticeable when the number of posts gets into the thousands. This appears to be something like O(n log n). The numbers go from roughly 100 posts in 3 seconds with no entries to 100 posts in 30 seconds with 1000 entries.
Has anyone else experienced this and if so is anyone working on it?
Our guess is that there is an unoptimized query running on the posts table before the insert but this is totally preliminary.