[wp-trac] Re: [WordPress Trac] #8958: Huge amount rewrite rules for page revisions after upgrade

[WordPress Trac]

#8958: Huge amount rewrite rules for page revisions after upgrade
--------------------------+-------------------------------------------------
 Reporter:  matthijs      |       Owner:  ryan                   
     Type:  defect (bug)  |      Status:  new                    
 Priority:  normal        |   Milestone:  Future Release         
Component:  Permalinks    |     Version:  2.7                    
 Severity:  major         |    Keywords:  has-patch needs-testing
--------------------------+-------------------------------------------------

Comment(by onezero):

 To test this patches I used the result of "SELECT LENGTH(option_value)
 FROM `wp_options` WHERE option_name LIKE 'rewrite%'" to benchmark. Along
 with a walk through the website to notice differences. The installation in
 which tests are performed has 200 posts, 100 pages, 35 categories, and
 started out in 2008.

 The original situation was the custom permalink setting
 "/%category%/%year%/%postname%", the result of the query was +/- 1.400.000
 chars. After applying patch 8958.diff the result was +/- 1.400.000 chars.
 After applying patch reduce_attach_query.8958.diff the result was +/-
 145.000 chars. A significant difference.

 Following the hint of justinph (see above) to use a fixed prefix
 ("/list/%category%/%year%/%postname%") the result in the original
 (unpatched) situation is +/- 8.000 chars. An even more dramatic
 improvement than the results achieved by the fixes, but at a cost:
 (slightly) different URLs. An equal result was achieved by moving a less
 variable parameter to the front of the setting:
 "/%year%/%category%/%postname%"): +/- 7.500 chars.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/8958#comment:22>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software