Dear FireBoard users,
In order to further develope the need of Joomla for a robust forum, FireBoard component has been moved to its own new home and new name. You can find more information regarding the Kunena, the successor of FireBoard, at kunena.com. The current forum here will stay for some time more for referencing needs. You can find the FireBoard files under joomlacode.org and other files
Upgrading to Kunena is highly recommended!

Kunena! - To Speak!

A revolution is coming... Kunena - Swahili for: To Speak! THE Next generation of native Joomla based Forum ultra component. Forget what you know about Joomla based forums...
Amazingly Simple Lean and Clean Easier Customization
Kunena is about to redefine the world of Joomla! with the most simplistic ultra component out there. For ultimate performance based on state of the art development techniques, Kunena! is about to bring you... With an integrated plugin system that will allow you to extend Kunena beyond your wildest imaginations...
1.0.0 to 1.0.3 extra steps to Boost Performance!!
TOPIC: 1.0.0 to 1.0.3 extra steps to Boost Performance!!
#21492
1.0.0 to 1.0.3 extra steps to Boost Performance!! 10 Years, 2 Months ago  
Thanks very much to the Fireboard team for 1.0.3

I have just upgraded from 1.0.0 (or 1.0.1) - i was between the 2 i think.

Anyhow i followed the provided instructions (pdf in the download pack).

Everything went pretty smoothly.

Got some SQL errors due to trying to re-add existing keys (or drop non-existent ones) but luckily I am comfy enough with SQL that i knew these were OK.

The main point of my post is this.......
after applying the change script everything worked fine.

But a couple days later I decided to double check that my fireboard SQL tables exactly matched the tables in the document provided (again in the download pack).

And .... I noticed that a bunch of keys were missing...
particularly on fb_messages and fb_users

So i added these keys (i.e. added the ones documented in the 1.0.3 DB structure that were not present on my converted 1.0.0 DB)

And...............

After adding these indexes FIREBOARD REALLLLYY FLIES!!!!!!

This is soo soo soo much better then any of the functional enhancements.

My site is getting busier ever day and now the forum is slick, responsive and that can only encourage more users and more posts.....THANKS SO MUCH FIREBOARD TEAM.

So to give a little back here (for others converting from 1.0.0) is my SQL to add the missing keys that the official upgrade process missed):

/* Alter table in Second database */
alter table `jo_fb_messages`
add KEY `thread`(`thread`),
add KEY `parent`(`parent`),
add KEY `ip`(`ip`),
add KEY `catid`(`catid`),
add KEY `userid`(`userid`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jo_fb_moderation`
add PRIMARY KEY (`catid`,`userid`), COMMENT=\'\';


/* Alter table in Second database */
alter table `jo_fb_sessions`
add PRIMARY KEY (`userid`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jo_fb_subscriptions`
add KEY `thread`(`thread`),
add KEY `userid`(`userid`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jo_fb_users`
add PRIMARY KEY (`userid`), COMMENT=\'\';

Hope that helps some of youB)
#21492
1.0.0 to 1.0.3 extra steps to Boost Performance!! 10 Years, 2 Months ago  
Thanks very much to the Fireboard team for 1.0.3

I have just upgraded from 1.0.0 (or 1.0.1) - i was between the 2 i think.

Anyhow i followed the provided instructions (pdf in the download pack).

Everything went pretty smoothly.

Got some SQL errors due to trying to re-add existing keys (or drop non-existent ones) but luckily I am comfy enough with SQL that i knew these were OK.

The main point of my post is this.......
after applying the change script everything worked fine.

But a couple days later I decided to double check that my fireboard SQL tables exactly matched the tables in the document provided (again in the download pack).

And .... I noticed that a bunch of keys were missing...
particularly on fb_messages and fb_users

So i added these keys (i.e. added the ones documented in the 1.0.3 DB structure that were not present on my converted 1.0.0 DB)

And...............

After adding these indexes FIREBOARD REALLLLYY FLIES!!!!!!

This is soo soo soo much better then any of the functional enhancements.

My site is getting busier ever day and now the forum is slick, responsive and that can only encourage more users and more posts.....THANKS SO MUCH FIREBOARD TEAM.

So to give a little back here (for others converting from 1.0.0) is my SQL to add the missing keys that the official upgrade process missed):

/* Alter table in Second database */
alter table `jo_fb_messages`
add KEY `thread`(`thread`),
add KEY `parent`(`parent`),
add KEY `ip`(`ip`),
add KEY `catid`(`catid`),
add KEY `userid`(`userid`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jo_fb_moderation`
add PRIMARY KEY (`catid`,`userid`), COMMENT=\'\';


/* Alter table in Second database */
alter table `jo_fb_sessions`
add PRIMARY KEY (`userid`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jo_fb_subscriptions`
add KEY `thread`(`thread`),
add KEY `userid`(`userid`), COMMENT=\'\';

/* Alter table in Second database */
alter table `jo_fb_users`
add PRIMARY KEY (`userid`), COMMENT=\'\';

Hope that helps some of youB)
#21531
Re:1.0.0 to 1.0.3 extra steps to Boost Performance 10 Years, 2 Months ago  
Thanks
Should the default prefix be \"jos_\" instead of \"jo_\" ?
#21559
Re:1.0.0 to 1.0.3 extra steps to Boost Performance 10 Years, 2 Months ago  
Nice one my friend,

Also note that jo_ should probably be jos_ if your database has that prefix.

Very cool that you\'ve done this.

Clinton
#21572
Re:1.0.0 to 1.0.3 extra steps to Boost Performance 10 Years, 2 Months ago  
Yes - sorry u r both correct.

Change the jo_ in the above SQL to whatever is your prefix for your joomla tables (e.g. typically jos_ but can be whatever u set it to)
Page: 1