danialt wrote:
OK guys. I tell you what? I'm now going to start moving the database of my client from SMF to FB with 100k posts and 3k+ users. What will you get? A converter and a better db calls, I hope

As I said before, do not move totally to FB, keep it there and test it. leave your JB in place (if your forum is the main part of your site)

C00L , finally your professor released you it seems

danialt wrote:
OK guys. I tell you what? I'm now going to start moving the database of my client from SMF to FB with 100k posts and 3k+ users. What will you get? A converter and a better db calls, I hope

As I said before, do not move totally to FB, keep it there and test it. leave your JB in place (if your forum is the main part of your site)

Sounds good to me

Chrigu

Whoever is willing to test this out, please do, but do backup your database first. Execute the following queries and let us know if the speed has improved:
[code:1]ALTER TABLE `jos_fb_categories` DROP INDEX `catid` , ADD PRIMARY KEY (`id` )
ALTER TABLE `jos_fb_categories` ADD INDEX `published_pubaccess_id` (`published` , `pub_access` , `id` )
ALTER TABLE `jos_fb_messages` DROP INDEX `id`
ALTER TABLE `jos_fb_messages` DROP INDEX `time_2`
ALTER TABLE `jos_fb_messages` ADD INDEX `hold_time` ( `hold` , `time` )
ALTER TABLE `jos_fb_messages_text` DROP INDEX `mesid` , ADD PRIMARY KEY ( `mesid` )
ALTER TABLE `jos_fb_moderation` DROP INDEX `catid`[/code:1]

Once again, nothing bad should happen, but do a backup anyway. Pay attention to your database prefix. If any of the queries fail, you can safely ignore it.
Danial - this is the set of changes that made it in the latest joomlaboard and that improves the database performance. I checked and some of it is missing in fireboard database tables.
Thanks go to Community Builder team who analyzed the problem and provided me with the proposed changes.

Now, feedback! :)

Hi,

I have try it. But it wasnīt successfull. The DROPs donīt run because of auto-increment or primary keys... I have droped them then manuall. Then I add the new index to tables.
But it runs as slow as before

Thanks for the feedback and sorry to hear it did not help. Must be the additional queries introduced in Fireboard. We will nail them down eventually, please have some patience, this is the initial release and there are a lot of things that need to be ironed out.

No Problem. It is a BETA. And my Community is an hardcore-test

I will try a little bit in database (iīm software developer; but not PHP)

Just out of curiosity

how many users DO you feel this new board should be able to handle?

or

should one stay with SMF for the time being and move to FB at a later date?

Also, I think FireBoard 1.0.0 BETA has some unnecessary codes.

I wish these codes will be cleaned with stable release of FireBoard.

I trust Best Of Joomla Team

Hello,

are there new information how speed up fireboard?
All my tests in database where failed. now better performance. i think the database is optimized...

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.