rewrite_rules — at Version 1
|Reported by:||obscurecloud||Owned by:|
Description (last modified by SergeyBiryukov)
This may or may not be the place for this.
I've seen this issue debated in another ticket and it's marked resolved.
I'd like to put a different point of view into the debate.
I have a site with 2800 pages and growing by about 20 per day.
The size of the wp_options filed rewrite_rules (3MB and 3,000,000 characters in this one field)) was crashing my server consistently until I changed the permalink structure.
It recently crashed my server due to the permalink structure of category/postname and was very hard to track down that this was the cause. The severity of the problem and ease of reproducing should garner some attention to this issue.
First I'd like to point that while you all know that this is not the best way to do it for performance reasons, that info is not readily available to the average web developer using WordPress.
My fist suggestion is that if you don't change the way WP stores the rewrite rules, you put a notice on the permalink page about the performance issues of this type of permalink.
My second suggestion is that this type of permalink structure be better supported for obvious reasons. It's popular, easy to read, and many people believe it enhances SEO. WordPress is used as a CMS more often these days.