‘720 queries. 0.473 seconds’ … Is that a lot?

thats a crapload of queries. If i were your host, and you had any decent amount of traffic, why I’d …

WHAT plugins do you have installed??

720 queries is an insanely high number of queries. I use like 30-40 plugins and only have 24 queries on the front page.

I’ll have a list of my active plugins posted here in a few moments …

Here they are:

Add User Photo 0.2
Akismet 2.0
Anarchy Media Player 2.0 beta
Chunk Urls for WordPress 2.0
Contextual Related Posts 1.1
Cruftless Search 0.2
deUncategorize 1.1a
Get Author Profile 0.5.1
Get Recent Comments 1.5.5
Javascript Pullquotes 1.0.0
More Pararagraphs 1.0-b1
Optimal Title 1.0
Pierre’s Wordspew 2.95
ProtectContent 1.0
Role Manager 1.4.5
SimpleTags 1.1
Sociable 1.0
Spelling Checker 1.18
Subscribe To Comments 2.1
TDO Mini Forms 0.2
Text Link Ads 3.0.1
Viper’s Video Quicktags 5.1.2
WP-AddQuicktag (de) 0.4
WP-ContactForm 1.4.4
WP-DBManager 2.05
WP-phpMyAdmin 2.8.2

Chunk Urls for WordPress 2.0

that ones safe ??

Gee. thanks. ??

I guess my question is this: I’ve removed and deleted a huge number of unused plugins, including Sidebar Widgets. But I’m still getting about 700 queries. Are there still tables in my database that should be deleted? If so, is there a way to do that painlessly?

the amount of queries wont be reduced by deleting tables.

What you need to do is to figure out what plugin(s) are causing the problem, and trust me, 700+ queries on a single page load is a huge problem.

Disable 2 plugins at a time, check the amount.. even better disable each plugin one at a time, and write down the amont of queries you lose. I’m sure I dont have to do the math for you.

I will be adding this post to my favorites, I’m actually VERY interested in hearing what you find out.

I am happy you find this sooooo entertaining.

So, I followed your advice.

Deactivating Anarchy Media Player reduced queries from 721 to 666. That’s a start.

No effect: Add User photo, Akismet, Chunk URLs, Cruftless Search, Contextual Related Posts, Filosofo Old-Style Upload, Iimage Browser, Get Author profile, Get Recent comments, Javascript Pullquotes, Lazy-K Gallery. More-Paragraphs, Optimal Title, Protect Content, Role Manager, Spelling Checker, Simple tags, Sociable, Subscribe to Comments, WP-Contact Form, WP-Add Quicktags, WP DB Manager.

Deactivating Pierre’s WordSpew, TDO Mini Forms, Viper’s Video Quick Tags each ended one query.

I had already deleted WP-phpmyadmin.

End result: I’m down to just 666 queries.

thats after deactivating ALL the plugins, or no????

and I dont really find it entertaining — this is actually a post that isnt a run of the mill, my sidebar dropped, I cant read the codex will you read it for me question.

Im intrigued.

Yes. After deactivating them one at a time.

And I am NOT offended at your amusement at my problem.

??

I almost DON’T want to contact by server people, as they may banish me if they find out.

OK: At this very instant, I have NO plugins installed. And I am being told b the little announcement at the bottom of my theme that I made 642 queries in 0.511 seconds.

Is it possible that this little blurb in just plain out wrong? How can I check?

For the record, my homepage footer says (1.408 sec,554 qrs), which seems a lot. I wonder if it’s just miscalculating for some reason, cuz I think the page loads reasonably fast and my host hasn’t complained. I have several plugins — fewer than you, but very few overlapping like Akismet. Could it be something in the theme design, rather than a plugin?

Dgold: What theme are you using?

i’m just using an old Default Theme (Kubrick) that I hacked in different places. My novice meddling in the theme code could’ve done something strange. the fact my theme looks like kubrick (my hacks don’t change that) and i’m tired of the theme is 1 reason i don’t post the link here but you can find it googling my name pretty easy if you want to see. By the way your theme looks nice, I gotta switch to 3 column and 1024 width or fluid width soon.

Is there a way to echo a list of what the queries are querying?