I have a mysql server with only 1 small 50mb database. How could i get the best response time? - in memory db
I thought I could put the whole MySQL DB store in memory when the shares for HD, etc. are made
In Memory Db I Have A Mysql Server With Only 1 Small 50mb Database. How Could I Get The Best Response Time?
6:45 PM
1 comments:
There are some small problems can cause you to get a better response time to resolve.
A good way is to start the optimization of queries:
http://mcloide.wordpress.com/2009/06/24/ ...
Then you can start thinking about optimizing MySQL server itself: http://dev.mysql.com/tech-resources/pres ...
Anyway, a tip, if the query uses * for all columns that are longer than the reporting of all required column names in a query, therefore intensively use more server resources.
Post a Comment