tag:blogger.com,1999:blog-7583720.post114693501478275509..comments2024-03-05T03:17:02.289-08:00Comments on Salmon Run: Performance Tuning ThoughtsSujit Palhttp://www.blogger.com/profile/06835223352394332155noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7583720.post-13992042981720863002008-09-13T09:45:00.000-07:002008-09-13T09:45:00.000-07:00Hi Hemant, yes, query caching is definitely a good...Hi Hemant, yes, query caching is definitely a good tool to improve performance, especially in shops where multiple application copies are backed by a single database (I realize now that this scenario is far more common than when I wrote this post originally :-)). Even if replication is used, I think there would still be benefit from using the database query cache. Thanks for pointing it out.Sujit Palhttps://www.blogger.com/profile/06835223352394332155noreply@blogger.comtag:blogger.com,1999:blog-7583720.post-13805944642171542252008-09-09T18:36:00.000-07:002008-09-09T18:36:00.000-07:00Hi Sujit,I appreciate your efforts of summarizing ...Hi Sujit,<BR/><BR/>I appreciate your efforts of summarizing important stuff for performance tuning, wonderful job. I would like to add one more thing in that - Use of Query Caching in MySQL Server, as it caches the queries and can provide comprehensive solution against the need of storing frequently accessed data in data structures in JVM . This approach is not a replacement of the previous Hemant Patelhttps://www.blogger.com/profile/06409299656897320696noreply@blogger.com