Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread matthijs
On Thu, Jan 29, 2009 at 1:29 AM, DD32 wordpr...@dd32.id.au wrote: As mentioned on that ticket, If you're using a sane rewrite pattern, then theres no problem at all, Most people will have about 20 rewrite rules no matter how many posts/attachments/pages they have. I would not consider

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Otto
On Thu, Jan 29, 2009 at 2:12 AM, matthijs matthijsena...@gmail.com wrote: I understand your explanation (good summery btw), but my point is that the problem is not that there are so many rewrite rules, but that all of them are placed in a single serialized string in one table field. That

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread matthijs
Is that true? Do you really need to load - all - rules every time? I do understand that's the way it's currently done. But is there absolutely no way to design it in a different way? So that for example, you first look at the request bit by bit and then load only what's needed?

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Otto
On Thu, Jan 29, 2009 at 3:14 AM, matthijs matthijsena...@gmail.com wrote: Is that true? Do you really need to load - all - rules every time? I do understand that's the way it's currently done. But is there absolutely no way to design it in a different way? So that for example, you first look at

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread matthijs
On Thu, Jan 29, 2009 at 11:07 AM, Otto o...@ottodestruct.com wrote: On Thu, Jan 29, 2009 at 3:14 AM, matthijs matthijsena...@gmail.com wrote: Is that true? Do you really need to load - all - rules every time? I do understand that's the way it's currently done. But is there absolutely no

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Paul Robinson
I am a PHP coder, but WordPress has always kinda stumped me a little. So I was wondering if anyone could tell me if I would encounter this problem using the %postname%/%post_id% permalink structure. I have nearly 18000 entries (between posts, attachments etc.) in the wp_post table my site still

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread scribu
On Thu, Jan 29, 2009 at 3:22 PM, Paul Robinson pablorobin...@gmail.comwrote: I am a PHP coder, but WordPress has always kinda stumped me a little. So I was wondering if anyone could tell me if I would encounter this problem using the %postname%/%post_id% permalink structure. I have nearly

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Paul Robinson
Ahhh, I was hoping that was all that was meant. Yes, I always used to use just post id, but as far as Google other search engines are concerned you might as well jump of a large cliff into obscurity. :P That's why I chaged to post name post id. Paul. 2009/1/29 scribu scr...@gmail.com On Thu,

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Otto
On Thu, Jan 29, 2009 at 5:43 AM, matthijs matthijsena...@gmail.com wrote: Again, I understand that in the - current - wordpress design this is how it goes. But if you forget the current design for a moment, and think about how you could otherwise design a system handling permalinks. I can

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Otto
On Thu, Jan 29, 2009 at 5:43 AM, matthijs matthijsena...@gmail.com wrote: Again, I understand that in the - current - wordpress design this is how it goes. But if you forget the current design for a moment, and think about how you could otherwise design a system handling permalinks. I can

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Paul Robinson
I'd just like to chip in here and say bravo to Otto. In one fell swoop you have just explained to me how WP does a lot of things with it'd DB why you shouldn't use the category, post name combo for your permalink. You should be a teacher. :P Paul. 2009/1/29 Otto o...@ottodestruct.com On Thu,

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Stephen Rider
On Jan 29, 2009, at 5:43 AM, matthijs wrote: On Thu, Jan 29, 2009 at 11:07 AM, Otto o...@ottodestruct.com wrote: For the specific case that we're talking about, yes, you need them all. The key here is the category and/or postname. These are just arbitrary strings. So you need all the strings

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Austin Matzko
On Thu, Jan 29, 2009 at 5:43 AM, matthijs matthijsena...@gmail.com wrote: Again, I understand that in the - current - wordpress design this is how it goes. But if you forget the current design for a moment, and think about how you could otherwise design a system handling permalinks. I can

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread matthijs
It's a good explanation for how wordpress does things currently. Thanks for that. I still don't agree about the performance issue mysql vs php. The first page in any php/mysql book explains how you should build your code and queries in such a way that you retrieve out of the database exactly what

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Dan Milward
/me takes hat off in respect... I agree that is a totally good read. Now to take some of your logic and apply it to the WP e-Commerce Plugin (yeah!!!)... Ciao, Dan Paul Robinson wrote: I'd just like to chip in here and say bravo to Otto. In one fell swoop you have just explained to me how

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Otto
On Thu, Jan 29, 2009 at 1:43 PM, matthijs matthijsena...@gmail.com wrote: It's a good explanation for how wordpress does things currently. Thanks for that. I still don't agree about the performance issue mysql vs php. The first page in any php/mysql book explains how you should build your code

Re: [wp-testers] Bug....

2009-01-29 Thread mrmist
In message c3a04f3c0901291025h3d9e21f6y1f5db83f20696...@mail.gmail.com, Paleo Pat tpblogedi...@gmail.com writes Hello All, I just discovered a bug. I want to ask here, as to if it's been reported or not. Before I submit it. Quick Editor Link is not being displayed in Google chrome. That one

Re: [wp-testers] Bug....

2009-01-29 Thread Paleo Pat
I am now. I didn't know a new version came out. I will update the ticket. Doh! I can double check here -Paleo Pat http://www.politicalbyline.com On Thu, Jan 29, 2009 at 3:35 PM, mrmist listswptest...@mist.org.uk wrote: In message c3a04f3c0901291025h3d9e21f6y1f5db83f20696...@mail.gmail.com,

Re: [wp-testers] Bug....

2009-01-29 Thread Paleo Pat
disregard that double check stuff! -Paleo Pat http://www.politicalbyline.com On Thu, Jan 29, 2009 at 3:43 PM, Paleo Pat tpblogedi...@gmail.com wrote: I am now. I didn't know a new version came out. I will update the ticket. Doh! I can double check here -Paleo Pat

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread mrmist
In message 161617690901291054v249c043ch44c56affd3f22...@mail.gmail.com, Otto o...@ottodestruct.com writes 1. Is it a page? select from wp_posts where post_slug = mypost and post_type = page. Nope. snip 3. Is it a post? select from wp_posts where post_slug = mypost and post_type = post.

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Otto
On Thu, Jan 29, 2009 at 2:44 PM, mrmist listswptest...@mist.org.uk wrote: Putting the rest of the post to one side for a moment, does WP actually do this? No. It uses the rewrite_rules array to eliminate the need to do this sort of thing. -Otto ___

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Engel Sanchez
After reading this interesting discussions now I will change permalinks for a site I will launch next week that was based on %category% URL for posts. And it should be a big site soon. So now I am planning to go with: http://domain.com/%postname%/%post_id% or

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Paul Robinson
Engel, my 2 cents (or pounds seeing as I'm in the UK) I've been using the first one for quite a long time in three blogs google has always loved it. There might be a better way, but as far as I've seen it works great, not that there is much difference between the two versions. I've always

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Engel Sanchez
Thanks Paul... I think I will go with http://domain.com/%post_id%/%postname% look prettier in the URL. One question after this discussion about the wp pages problem. Do this affect plugins that are installed in ONE page and after that create their own URL... example: www.domain.com/forum

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread matthijs
I would also like to know in which ways exactly wordpress has this scaling problem. The issue I had was specifically with %category%//%year%/%monthnum%/%day%/%postname%/ removing the %category% removed the problem. But that wasn't possible in this case. Or, as I have done now as a temporarily

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Ryan Boren
On Thu, Jan 29, 2009 at 1:05 PM, Engel Sanchez en...@solunion.com wrote: After reading this interesting discussions now I will change permalinks for a site I will launch next week that was based on %category% URL for posts. And it should be a big site soon. So now I am planning to go with:

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Otto
On Thu, Jan 29, 2009 at 3:28 PM, Engel Sanchez en...@solunion.com wrote: Thanks Paul... I think I will go with http://domain.com/%post_id%/%postname% look prettier in the URL. I don't really get why people are so against the year/month/day/name layout. It doesn't affect SEO one little bit, and

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Paul Robinson
Uniquness? I don't know. I think I'd read somewhere that it was a bad format. Now of course I realise I was having my leg pulled, but I didn't think you could change your permalinks that drastically, or can you? I was considering changing them but will redirection handle that sort of permalink

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread DD32
2009/1/30 matthijs matthijsena...@gmail.com: Now wordpress will write rewrite_rules for all those attachments. If you have a page with 30 attachments, for each it gets maybe 11 rules, then you have more then 300 rules for a single page, from which 90% is not needed anymore. So maybe this is

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Otto
On Thu, Jan 29, 2009 at 4:29 PM, Paul Robinson pablorobin...@gmail.com wrote: I was considering changing them but will redirection handle that sort of permalink change? Sometimes the canonical 404 guessing function can handle it. Not often. There are plugins which can handle this though.

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Mike Little
I've been following this thread with great interest. I had seen in a couple of places on the forum, the assertion that lots of pages didn't scale, whereas lots of posts do. But could not find a anything concrete to back it up. Things are starting to make sense now. I encountered a problem last

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Paul Robinson
Thanks for that Otto. I've used the Permalink Redirect switched my permalinks back to the classic year/month/day/postname. It looks a lot better to me that plugin works like a dream. Thanks once more. Paul. 2009/1/29 Otto o...@ottodestruct.com On Thu, Jan 29, 2009 at 4:29 PM, Paul Robinson

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread DD32
At some point in the past, ALL pages were stored in the rewrite array, for each page, you had an extra rewrite rule, This changed though at some point in the last few releases, Which is where the Verbose rules was introduced..so now only verbose rules are used if they're needed, and for pages,

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Otto
Yes, the verbose page rules only get invoked when the permalink string *starts* with one of those four things. On Thu, Jan 29, 2009 at 3:59 PM, Paul Robinson pablorobin...@gmail.com wrote: Ryan, just a quick question. Does that mean that if you don't begin your permalink with one of those then

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Paul Robinson
K, gotcha. :P I was just thinking earlier today that all had been quite on the WP dev front and then all of a sudden this epic email/thread comes from no where. Twas a great read though. :) Paul. 2009/1/29 Otto o...@ottodestruct.com Yes, the verbose page rules only get invoked when the

Re: [wp-testers] Wordpress scaling problems

2009-01-29 Thread Engel Sanchez
Sorry I resend this question, but maybe it was overlooked. One question after this discussion about the wp pages problem. Do this affect plugins that are installed in pages and after that create their own URL... example: www.domain.com/forum In that case forum is a wp page, and a forum