I've just installed Fireboard to a test build of my site and it is also running very slowly.

I have quite a few posts and topics in each category and it seems the performance really degrades for categories with more that 40 threads and approx 200 posts.

Anyone that would like to look at my test site you'll find it here, it has low and high volume categories on it so is a good example.

Anyone that has any solutions to this please let us know. As I note this site runs fine with larger sized forums.

Cheers

Post edited by: adders, at: 2007/04/28 14:06

danialt wrote:
You are right. yesterday i tried it with 100k posts and 4k users and it took 20 seconds to load the main page. did some modifications to db and fb and now it is loading under 2 sec. It's ok I guess. You will have it for stable as well.

That's great Danialt, when can we expect the stable release?

Cheers

Paul

I´m anxious...

Running a Forum with
Messages: 15931 subjects: 1377 Sections: 3 Categorieen: 25

It's running now besides Joomlaboard (only admin). Compliments for the work done so far. Speed indeed is a problem and the 20 secs loadtime is the truth frankly spoken.

I hope the stable version is much faster. If you are running updated forum here I think things will be allright and I hope stable is here soon...........

LeonZ wrote:
Running a Forum with
Messages: 15931 subjects: 1377 Sections: 3 Categorieen: 25

It's running now besides Joomlaboard (only admin). Compliments for the work done so far. Speed indeed is a problem and the 20 secs loadtime is the truth frankly spoken.

I hope the stable version is much faster. If you are running updated forum here I think things will be allright and I hope stable is here soon...........

The problem is Simple. There are no indexes barely for the component. If you look at MySQL, the tables have ONE index if any and its usually the primary key. So if you do a search for post say by date, catid, or anything else besides the primary key, and you have a ton of posts then it will have to search EVERY SINGLE RECORD!

I am have spoken with a developer and will be forwarding correct table structures and indexes soon so that it can be includes with the next release, and fix this issue

I found a little jewel that is promised to speed things up a bit, see my post about a useless query in the always called stats class.
Memory exhaustion -- resolved!

REPLACED WITH

[code:1]
//Popüler 10 konu (mesaj sayısına göre)
$query = "SELECT COUNT(*)
FROM #__fb_messages
WHERE moved=0
AND hold=0
AND parent>0";

$database->setQuery($query);

$total = $database->loadResult();
[/code:1]

Works great for me, the loadResult() method in the database object is the PREFERED method for getting a count using the COUNT(*) MySQL function... WIth COUNT(*) it never actually has to gather the data just count how many rows it WOULD have to get if it were a real query.

danialt wrote:
You are right. yesterday i tried it with 100k posts and 4k users and it took 20 seconds to load the main page. did some modifications to db and fb and now it is loading under 2 sec. It's ok I guess. You will have it for stable as well.

In the mean time sort your indexes in the database out (make sure each has a primary with no duplication, and an index of the main fields that the database will search on catid, thread, id, userid etc.) and then turn off STATS in the Fireboard admin component (front end). A work-around while you wait for stable 1.0.

Post edited by: downunder, at: 2007/05/04 06:53

Turning off stats helped tremendously.
Thanks.

I wish I could say the same. I am using the latest SVN version and have stats disabled and the forum homepage still takes anywhere from 10 to 20 seconds to load.

Is there anything else I could try to resolve this and get things moving faster?