CODEWITHSUNDEEP
mysqlmemcached
Rachel
Rachel

Reputation: 103397

Usage of Memcache to improve performance of MySQL Query

  1. Is is always advantages to use memcache to improve performance of MySQL query ?
  2. Are there any downsides of extensive use of Memcache ?

Upvotes: 0

Views: 408

Answers (1)

Chris
Chris

Reputation: 27384

If you have slow queries the first thing you should address is the query itself as well as your table setup.

Usually altering the query to take advantage of indexes as well as maintaining correct indexes on your tables will actually dramatically reduce the query time of your SQL. Keeping this down will also allow MySQL to cache queries itself taking the earnest off you.

What is your need to cache your queries external to MySQL itself?

Upvotes: 1

Related Questions