[wp-hackers] Permalink Performance

[Ryan Bilesky]

I made an interesting discovery today, I use a permalink of /blog/%postname%

Now while having another rewrite rules issue I install this plugin (
http://wordpress.org/extend/plugins/askapaches-rewriterules-viewer/)
according to it, my blog is using verbose page rewrite rules.

Now performance wise this isn;t much of an issue as I won;t have probabbly
more than 50 pages or so, but this is causing another issue when I modify
the sql queries of one blog to pull posts, pages, and comments from another
blog on my multisite install.  see my other recent email about my subdomin
probllems with multisite.  I am using the query filter to change wp_#_table
to wp_table and everything works find, except pages, unless I copy the pages
to that sites table to create the rewrite rules.

Anyway just though I'd update this with my findings about using a static
string to start post permalinks.

On Thu, Sep 2, 2010 at 10:45 AM, Ryan Bilesky <rbilesky at gmail.com> wrote:

> According to http://codex.wordpress.org/Using_Permalinks
>
> Permalinks for posts should start with some sort of number.
>
> "For performance reasons, it is *not* a good idea to start your permalink
> structure with the category, tag, author, or postname fields. The reason is
> that these are text fields, and using them at the beginning of your
> permalink structure it takes more time for WordPress to distinguish your
> Post URLs from Page URLs (which always use the text "page slug" as the URL),
> and to compensate, WordPress stores a lot of extra information in its
> database (so much that sites with lots of Pages have experienced
> difficulties). So, it is best to start your permalink structure with a
> numeric field, such as the year or post ID."
>
> Now my question is this, I would like to have my permalinks for posts look
> like this:   mysite.tld/blog/%postname%
>
> Does anyone know if this will cause any performance issues since they start
> with a static string?
>