[wp-trac] [WordPress Trac] #39603: The more posts with similar names you have, the slower you save the next one

[WordPress Trac]

#39603: The more posts with similar names you have, the slower you save the next
one
-------------------------------------------------+-------------------------
 Reporter:  bisyarin                             |       Owner:
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Awaiting
Component:  Posts, Post Types                    |  Review
 Severity:  normal                               |     Version:
 Keywords:  needs-testing has-patch has-unit-    |  Resolution:
  tests                                          |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------

Comment (by bisyarin):

 Hello!

 If you decide to choose the original way of filling gaps in slugs
 numbering (it's of course slower than the second patch's way), than I've
 attached patches for 'src' and 'tests'. These are my tests results for
 this approach:

 Fresh database on each run: 92.5 seconds for 1000 objects (avg of two
 runs)
 With 10 000 records already in DB:  419 seconds for 1000 objects (average
 of three runs)

--
Ticket URL: <https://core.trac.wordpress.org/ticket/39603#comment:9>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform