Page 1 of 1

MyISAM or InnoDB? What is the ideal configuration for optimal performance?

Posted: Thu Mar 30, 2006 5:07 pm
by marvado
Hi,

What is the ideal configuration for optimal performance? MyISAM or InnoDB? My site has reasonably low load and not many pages (under 20). It just seems a little slow. How can I speed it up?
I already posted another topic for a way to export pages to flat .php files (http://forum.cmsmadesimple.org/index.ph ... 938.0.html), without answers yet.

Appreciate any input
thanks,
-Pedro

Re: MyISAM or InnoDB? What is the ideal configuration for optimal performance?

Posted: Thu Mar 30, 2006 5:11 pm
by calguy1000
well, you could configure the mysql cache, that would help considerably.  enable some compression on output in your php.ini or apache configuration (both have their drawbacks though).

just some ideas.

Re: MyISAM or InnoDB? What is the ideal configuration for optimal performance?

Posted: Fri Mar 31, 2006 5:27 am
by cyberman
1. Use the last stable CMSms version.
2. Activate caching for all pages.
3. Delete all unused modules and tags. Be sure they are really unused.
4. Include your stylesheet from external source with a link.
5. Ask your provider about server resources (processor, ram, how many sites works on server). Perhaps it will be better to change  ;D ...

Also just some ideas ...