30 Queries, is this alot ? How much do you have ?

[Mupetz]

Hi,

I've just run the debug and got 29 queries on forum home. Version 3.6.5 with several mods.
God damn, that's a lot of queries; normally the clean vbulletin doesn't have more than 10. I think it's time for me to stop installing any mods.
How much queries do you guys have ?

Also, i'm running on godaddy normal hosting with normal speed.

[Kier]

vBulletin.com itself runs 9 queries on forumhome.

[JakeS]

55, I've started a lot of modifications and never finished them so its running useless queries.

Which reminds me, I gotta remove them.

[rellek]

Page generated in 0,19187 seconds with 12 queries

At forumshome.

[filburt1]

The number of queries is irrelevant compared to their efficiency. I have a project at work which (necessarily, trust me; it's a statistical report) runs 217 queries on 0.3 seconds on crappy MySQL. And those queries are scanning hundreds of thousands of rows and joining in some other data.

[simsim]

Hmm.. still a large number of queries would indicate - in many cases - bad optimization. What do you mean exactly by efficiency?

[RedTyger]

Not really. A lack of optimisation is doing what needs to be done inefficiently. If you need a lot of queries to do what you need to achieve, it's not inefficient. It's just high-powered (probably, but as filbert said, not necessarily).

[Mupetz]

queries

I added this 2 lines on header to make the queries run in the background. This way, the forum seems more faster.

<META http-equiv=Page-Exit content=BlendTrans(Duration=0)>
<META http-equiv=Page-Enter content=BlendTrans(Duration=0)>

BoYagoob posted this vb.org.

Definitely needed by thous running several queries, like you JakeS. (50 omg)

If you have any more tips, please share.

[Zachery]

I don't see how IE page transitions speed the page up at all...

[FreshFroot_]

I added this 2 lines on header to make the queries run in the background. This way, the forum seems more faster.

<META http-equiv=Page-Exit content=BlendTrans(Duration=0)>
<META http-equiv=Page-Enter content=BlendTrans(Duration=0)>

BoYagoob posted this vb.org.

Definitely needed by thous running several queries, like you JakeS. (50 omg)

If you have any more tips, please share.

Seems faster or it DID get faster? I have yet to check my queries, but I think I'll need to cut down on some... My forums are become slugish lately..

[Omri.L]

I added this 2 lines on header to make the queries run in the background. This way, the forum seems more faster.

<META http-equiv=Page-Exit content=BlendTrans(Duration=0)>

[LEFT]<META http-equiv=Page-Enter content=BlendTrans(Duration=0)>[/LEFT]

BoYagoob posted this vb.org.

Definitely needed by thous running several queries, like you JakeS. (50 omg)

If you have any more tips, please share.

Huh ? i will be very surprised if this things actually works. The queries run before this info is even sent to your browser.

[filburt1]

Not really. A lack of optimisation is doing what needs to be done inefficiently. If you need a lot of queries to do what you need to achieve, it's not inefficient. It's just high-powered (probably, but as filbert said, not necessarily).

Yes, but what I mean is that 30 super-fast, well-written queries on a properly-indexed fifth normal form database are going to be much better than a single, poorly-written query on a not-even-third normal form database that lacks any indices or referential integrity.

Obviously you want the best of both worlds: a small set of queries that efficiently perform their tasks.

[Ace]

I added this 2 lines on header to make the queries run in the background. This way, the forum seems more faster.

<META http-equiv=Page-Exit content=BlendTrans(Duration=0)>
<META http-equiv=Page-Enter content=BlendTrans(Duration=0)>

BoYagoob posted this vb.org.

Definitely needed by thous running several queries, like you JakeS. (50 omg)

If you have any more tips, please share.

That just forces the browser to render the page differently.

It does nothing to queries.

[Mupetz]

That just forces the browser to render the page differently.

It does nothing to queries.

Ok so this can't do any damage.
The important thing is that it affects the page load ( positively ).
I will continue using it.

Btw i manage to remove 2 not so important queries. But eh, i don't see any difference.

[Zachery]

Ok so this can't do any damage.
The important thing is that it affects the page load ( positively ).
I will continue using it.

Btw i manage to remove 2 not so important queries. But eh, i don't see any difference.

It just makes you think it does.