WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #39603, comment 7


Ignore:
Timestamp:
01/20/2017 10:02:54 PM (9 years ago)
Author:
bisyarin
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #39603, comment 7

    initial v1  
    44I decided to try @rmccue's suggestion and perform natural sort on MySQL side, selecting needed rows for sorting with RLIKE. I didn't notice serious performance issues with LENGTH or RLIKE while running the tests listed below.
    55
    6 Ten Thousand Posts Creation Tests
     6Thousand Posts Creation Tests
    77
    88Original trunk code:
    … …  
    2020Although the second patch works about 40% slower than the first one, it's still a nice result comparing to the original performance.
    2121
    22 Unit tests for the issues discussed here have been created. Also I added an SQL-queries counting test.
     22Unit tests for the issues discussed here, especially with @pento, have been created. Also I added an SQL-queries counting test.
    2323
    2424In "phpunit\tests\post\wpUniquePostSlug.php" file, "test_embed_slug_should_be_suffixed_for_pages" test a typo has been found: paage -> page