FUDforum: FUDforum 3.0+ » Alot of Queries

Home » FUDforum Development » FUDforum 3.0+ » Alot of Queries

Show: Today's Messages :: Polls :: Message Navigator

Re: Alot of Queries [message #4815 is a reply to message #4813]

Wed, 07 August 2002 20:26

Ilia

Messages: 13241
Registered: January 2002

Karma:

Senior Member
Administrator
Core Developer

As anonymous user I've looked at thread #1 (test), this is the one with 4 replies.
According to the page stats, that page took 15 queries to generate and had reported the following timings:
15 MySQL queries took 0.0096697807312012 seconds
Total time taken to generate the page: 0.034555077552795 seconds

Thread #3 (no replies), took 14 queries to generate and had reported the following timings:
14 MySQL queries took 0.010731935501099 seconds
Total time taken to generate the page: 0.032771944999695 second

As you can see there is a difference of only 1 query, and that query is because thread #1 had a message with an attachment. As I've explained before attachments require additional query.

However, you were correct, in <2.2.3 versions there was a nasty bug, that caused a harmless query to occur for every message, that query occurred IF a user was not ignoring anyone and the ignore list array was blank. Which would cause a fast query to be ran on the ignore list table.
After looking at the CVS I see that this particular problem has been resolved somewhere along the lines during the 2.2.4X dev release.

FUDforum Core Developer

Report message to a moderator

[Message index]

		Alot of Queries By: MrDigory on Wed, 07 August 2002 16:41
		Re: Alot of Queries By: Ilia on Wed, 07 August 2002 17:01
		Re: Alot of Queries By: MrDigory on Wed, 07 August 2002 17:33
		Re: Alot of Queries By: Ilia on Wed, 07 August 2002 17:40
		Re: Alot of Queries By: MrDigory on Wed, 07 August 2002 18:24
		Re: Alot of Queries By: Ilia on Wed, 07 August 2002 20:26
		Re: Alot of Queries By: MrDigory on Thu, 08 August 2002 04:52
		Re: Alot of Queries By: Ilia on Thu, 08 August 2002 12:23

Previous Topic:	Most stable/functional version?
Next Topic:	hi!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 04:48:29 GMT 2024

Total time taken to generate the page: 0.04512 seconds