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:FireBoard very slow? (1 viewing) (1) Guest
Go to bottom Favoured: 2
TOPIC: Re:FireBoard very slow?
#3722
Re:FireBoard very slow? 1 Year, 7 Months ago  
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
adders (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Total Wargamer
Logged Logged
 
 
The administrator has disabled public write access.  
#3723
Re:FireBoard very slow? 1 Year, 7 Months ago  
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
adders (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Total Wargamer
Logged Logged
 
 
The administrator has disabled public write access.  
#3738
Re:FireBoard very slow? 1 Year, 7 Months ago  
I´m anxious...
MikeMH (User)
Junior Boarder
Posts: 26
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#4510
Re:FireBoard very slow? 1 Year, 7 Months ago  
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 (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#4812
Re:FireBoard very slow? 1 Year, 7 Months ago  
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
HolmesSPH (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#4897
Re:FireBoard very slow? 1 Year, 7 Months ago  
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!
Ritter (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#4908
Re:FireBoard very slow? 1 Year, 7 Months ago  
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.
HolmesSPH (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#4918
Re:FireBoard very slow? 1 Year, 7 Months ago  
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
downunder (User)
Junior Boarder
Posts: 24
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#5658
Re:FireBoard very slow? 1 Year, 6 Months ago  
Turning off stats helped tremendously.
Thanks.
nealbaker (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#6087
Re:FireBoard very slow? 1 Year, 6 Months ago  
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?
JaceRider (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
Go to top