var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
How to improve MySQL performance
Hi guy's, I'm building a intensive MySQL usage webpage, but I was thinkins what is the best to improve performance:
Have 1 big MySQL database, with multiple BIG tables, or to have multiple smaller databases?
Hope you can give me an advice, thanks
I am not a MySQL guru by any means but I would start by making sure your database is 3FN (Third Form Normal). Bit of a long read on the issue but here's a link: http://www.bkent.net/Doc/simple5.htm
What type of project are you taking on?
Make sure that your server have right hardware config for your needs. More the RAM,it is much better.
Also optimize the my.cnf.