Dear friends,

This may increase the performance of Joomla and Fireboard

Recently, I was working on vbulletin (a client's site) and there I came to know that it's SESSION table is of type MEMORY, rest of the tables are same MyISAM type.

So, Joomla+Fireboard has 2 SESSION tables, jos_session and jos_fb_sessions.
Both of them are MyISAM type.

So, changing them to MEMORY type may increase the performance of our sites. After all vbulletin is the BEST Forum-System in the world, so, if they are doing this, so there must be some performance gain with it.

Try it and report here....

Sorry, it wont. We are doing one session table access per page view. You would need 1,000,000s of visits per day before the session table becomes any sort of bottleneck.
Having said that, there are plenty of SQL statements that we can combine and save time for every page view.

Little more explanation will be helpful to understand.

Can'y understand the 'bottleneck' part..... I am looking for performance boost, not 'simultaneous access per second/day'

I found another Performance Boost method for Joomla and Fireboard.

Have a look here -
www.joomlaperformance.com/articles/perfo...as_queries_4_14.html