[wp-testers] Wordpress scaling problems

[matthijs]

> However, I dont think Verbose rules apply to attachments, You're
> likely to have 11~ish rules for attachements per post-rule, If you've
> got 500 post rules in the rewrite rules, you'll have 500*11 for
> attachments too.. Since most of us only have ~5 rules for every single
> post, theres less than 20 rules all together which accounts for posts,
> attachments, categories, archives, etc.
>


I am not sure what you mean. In my case, there are definitely 11 rules (22
lines) for each single attachment. So one of the pages has 26 attachments to
it. Now I counted all the lines for that single page:  about 570 lines.

///

So to summarize things a little:
The cause of the problem is the use of "verbose" rewrite structure: Verbose
rules are used for structures beginning with %category%,
%tag%, %postname%, and %author%. With verbose rules the field rewrite_rules
can get too big to be handled by PHP (memory problems), mysql should handle
it fine.
A few questions remain:

1) Is it only when you use those at the -beginning- of the permalink
structure?

2) If using %category% in the structure is not wise, how else are you
supposed to browse your blog/site by category?

3) What about the attachments? Why is it needed to also have many
rewrite_rules for attachments?
My guess would be that in most cases you just want to upload an image and
link to that. No need for any rewrite rule there isn't it?

4) Someone mentioned something about a change in the handling of media
planned for a future release. What changes are those or were can I find more
info on that?


By the way, thanks everyone for the great discussion so far. I'm sure I'm
not the only one having learned a thing or two.