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

how many categories you have?

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)

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 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 ?

Yup, only files.

Looks very promising. Only 588 queries now with statisticts enabled! Thank you very much!

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 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.

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