Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Manual Latest release discussions Download FireBoard Spread FireBoard!
Re:Is 6800 queries for fireboard normal? (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Re:Is 6800 queries for fireboard normal?
#19521
Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
Joomla 1.0.13
Fireboard SVN(302)

Fireboards mainpage is loading really slow for me (10 seconds), and when a lot of users are in it gets even worse.

I tried setting joomla in debug mode and saw that there where over 6800 queries when going to fireboard.
Is this normal? I have a big board and the number of queries coincides with my amount of threads which are also over 6800. Posts are 119 000 and members 3100.

Most of the queries are like:

SELECT MAX(time) FROM jos_fb_messages WHERE catid=58 and hold=0 AND moved!=1
crisscross (User)
Junior Boarder
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
Gender: Male husvagnsforum crizcroz@gmail.com Location: Umeå, Sweden Birthdate: 1969-10-22
Logged Logged
 
They f**k you at the drive-thru, ok?
 
The administrator has disabled public write access.  
#19536
Re:Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
how many categories you have?
danialt (Admin)
BoJ Team
Simplicity
Administrator
Posts: 957
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Birthdate: 1978-05-25
Logged Logged
 
Best Of Joomla Team
FireBoard Project Manager
 
The administrator has disabled public write access.  
#19539
Re:Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
danialt wrote:
how many categories you have?
I have 66 categories.
I tried disable forumstats and latest posts. That resulted in much faster loading but the number of queries is still high (6056)
crisscross (User)
Junior Boarder
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
Gender: Male husvagnsforum crizcroz@gmail.com Location: Umeå, Sweden Birthdate: 1969-10-22
Logged Logged
 
Last Edit: 2007/08/30 17:33 By crisscross.
 
They f**k you at the drive-thru, ok?
 
The administrator has disabled public write access.  
#19625
Re:Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
can you please try with the latest SVN, take backup of the com_fireboard directory first (or rename it)

I modified the codes alot (after your post) and needs testing and result.

let me know
danialt (Admin)
BoJ Team
Simplicity
Administrator
Posts: 957
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Birthdate: 1978-05-25
Logged Logged
 
Best Of Joomla Team
FireBoard Project Manager
 
The administrator has disabled public write access.  
#19628
Re:Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
danialt wrote:
can you please try with the latest SVN, take backup of the com_fireboard directory first (or rename it)

I modified the codes alot (after your post) and needs testing and result.

let me know

Ok. Am I getting it right that I only need to ftp the files up since there are no changes in the file FB_databaseStructure.txt ?
crisscross (User)
Junior Boarder
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
Gender: Male husvagnsforum crizcroz@gmail.com Location: Umeå, Sweden Birthdate: 1969-10-22
Logged Logged
 
They f**k you at the drive-thru, ok?
 
The administrator has disabled public write access.  
#19630
Re:Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
Yup, only files.
greendino (User)
Junior Boarder
Posts: 59
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#19631
Re:Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
Looks very promising. Only 588 queries now with statisticts enabled! Thank you very much!
crisscross (User)
Junior Boarder
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
Gender: Male husvagnsforum crizcroz@gmail.com Location: Umeå, Sweden Birthdate: 1969-10-22
Logged Logged
 
They f**k you at the drive-thru, ok?
 
The administrator has disabled public write access.  
#19633
Re:Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
well, yet is not perfect but good enough before the first stable release. we will do it better for 1.5 series for sure.
danialt (Admin)
BoJ Team
Simplicity
Administrator
Posts: 957
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Birthdate: 1978-05-25
Logged Logged
 
Last Edit: 2007/08/31 16:39 By danialt.
 
Best Of Joomla Team
FireBoard Project Manager
 
The administrator has disabled public write access.  
#19634
Re:Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
danialt wrote:
well, yet is not good enough but before the first release is good enough. we will do it better for 1.5 series.
Sounds good. For big boards performance is important.
crisscross (User)
Junior Boarder
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
Gender: Male husvagnsforum crizcroz@gmail.com Location: Umeå, Sweden Birthdate: 1969-10-22
Logged Logged
 
They f**k you at the drive-thru, ok?
 
The administrator has disabled public write access.  
#19637
Re:Is 6800 queries for fireboard normal? 1 Year, 1 Month ago  
I did a lot of checks on the update...
Anything within code looks fine, any presentation looks ok.
All tested roleplays where perfect...
...at least that perfect as before ... well ...

That's a really big step for us, i think!
Performance is directly usability and lower cost

Thanks, danialt
Miro Dietiker (User)
Senior Boarder
Posts: 155
graphgraph
User Offline Click here to see the profile of this user
Gender: Male miro_dietiker MD Systems miro.dietiker@md-systems.ch Location: Zurich, Switzerland Birthdate: 1980-10-30
Logged Logged
 
Boarding with FIRE .-) -- Professional OpenSource developer
 
The administrator has disabled public write access.  
Go to top