[wp-hackers] wordpress optimizations

[Peak Discharge]

I see you turn debug mode on using by adding ?debug=1 at the end of the blog 
address. I tried that but that didn't display what expected at the bottom. 
Using Strayhorn with Blix theme

On 4/16/05, denis at semiologic.com <denis at semiologic.com> wrote: 
> 
> Quoting Mike Little <journalized at gmail.com>:
> 
> > On 4/16/05, Peak Discharge <chmoka at gmail.com> wrote:
> > > I am also rather curious, why does query count on index increase
> > > proportionally to the number of posts on index? for example if you 
> install
> > a
> > > fresh wp 1.5 installation and make posts one by one you'll notice
> > > considerable query count increase. How come?
> > >
> 
> I had a similar problem because of plugins interacting with get_permalink
> functions and related. It is mostly solved in 1.5.1, I think: my recent 
> plugins
> only do two queries at most now, thanks to the caching.
> 
> There are other issues, though. Namely:
> 
> http://www.semiologic.com/cats/blog/?debug=1
> 
> is hardly optimal. It calls:
> 
> /* sem_sp_cats */ SELECT DISTINCT categories.*, COUNT( post_id ) > 0 AS
> has_posts FROM wp_categories AS categories ...
> 
> the above via my theme because:
> 
> SELECT * FROM wp_categories
> 
> is called after the 'init' rather than before, and doesn't tell if cats 
> are
> non-empty.
> 
> I've no clue where these come from:
> 
> SELECT cat_ID FROM wp_categories WHERE category_nicename = 'blog'
> 
> SELECT cat_name FROM wp_categories WHERE category_nicename = 'blog' x3
> 
> I think BA stats is responsible for one of the calls. The other four come 
> from
> WordPress. I dare add I am not listing a tree of categories.
> 
> As for why WordPress is querying for users, options, meta, comment counts, 
> etc.,
> or why the page needs > 0.4 seconds to be generated, I remain speechless 
> --
> Markdown and my resource hungry smart link plugin are neither called here.
> 
> --
> Denis
> http://www.semiologic.com
> 
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
> 



-- 
best regards, chmoka
mailto:chmoka at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://comox.textdrive.com/pipermail/wp-hackers/attachments/20050416/0ab71fa6/attachment.html