FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » Alot of Queries
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Alot of Queries [message #4807] Wed, 07 August 2002 12:41 Go to next message
MrDigory is currently offline  MrDigory   United States
Messages: 12
Registered: August 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I installe 2.2.3 on my server to run some initial tests and work on a style, but I foun something which sort of bothere me. For each reply in thread view, there seems to be an extra querie. It rapily went from a mere 8 to 30! That seems like a lot, and I also notice I can't get the forum to run as fast as it oes here.
Any suggestion?
Re: Alot of Queries [message #4810 is a reply to message #4807] Wed, 07 August 2002 13:01 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Hrm... I'll check about the query counts, are you referring to the thread list page which shows a list of threads within a forum or a tree view?

Well, there are number of things, which make a forum run faster, 1st ans formost is configuration of PHP. Since PHP needs to output lots of data turning on output buffering helps the page speed quite a bit. Also compiling PHP, MySQL & Apache with optimization options will add even more speed to your forum.


FUDforum Core Developer
Re: Alot of Queries [message #4811 is a reply to message #4807] Wed, 07 August 2002 13:33 Go to previous messageGo to next message
MrDigory is currently offline  MrDigory   United States
Messages: 12
Registered: August 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
No, inside a topic, for each shown reply there seems to be an extra query. The list of topics seems absolutely fine.

This is how many I have with about 5 replies and one attatchment.
31 MySQL queries took 0.049809217453003 seconds
Total time taken to generate the page: 0.13893806934357 seconds

It will go up to 32 if I make another reply.
Re: Alot of Queries [message #4812 is a reply to message #4811] Wed, 07 August 2002 13:40 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Okie, I'll check, this.
The message retrieval itself and majority of the data itself is fetched with 1 query. However, if a message has a poll or file attachments that would result in an additional query, which is needed to fetch the file attachment(s) or poll information.


FUDforum Core Developer
Re: Alot of Queries [message #4813 is a reply to message #4807] Wed, 07 August 2002 14:24 Go to previous messageGo to next message
MrDigory is currently offline  MrDigory   United States
Messages: 12
Registered: August 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
http://electriclove.org/forum
Re: Alot of Queries [message #4815 is a reply to message #4813] Wed, 07 August 2002 16:26 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Re: Alot of Queries [message #4822 is a reply to message #4807] Thu, 08 August 2002 00:52 Go to previous messageGo to next message
MrDigory is currently offline  MrDigory   United States
Messages: 12
Registered: August 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
When not logged in, the threa with four replies has 15 queries. When logged in (for me) 31.
Anyway, it is EXTREMEMLY faster to browse as a guest.

[Updated on: Thu, 08 August 2002 00:56]

Report message to a moderator

Re: Alot of Queries [message #4827 is a reply to message #4822] Thu, 08 August 2002 08:23 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Well, like I've said later version removes the unneeded queries, 2.2.4 includes many other optimizations as well.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Most stable/functional version?
Next Topic: hi!
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 23 22:27:57 EDT 2017

Total time taken to generate the page: 0.00757 seconds