I made the mistake of using %postname% as the permalink structure for my site. I just recently discovered that this structure is NOT recommended by WordPress as it means that WordPress automatically writes a WHOLE LOT of extra rewrite rules in wp-options table (more specifically the “rewrite_rules”) – slowing things down, which has been a big problem lately. This single row is well over 1 MB!
I’ve read that this issue is fixed in the WordPress 3.3, which is soon to come out. But I was hoping for some early help on how to migrate to 3.3, keeping the %postname% as a permalink structure.
Will I be able to “clean” up the wp-options table, deleting all of the unnecesery redirection rules, no longer needed?