On: Ask HN: Dealing with a huge MySQL database - help

[CWIZO]

Do you have any sort of caching in your app? Memcache, for instance, can go a long way in helping you scale.

[webvet → CWIZO]

We don't have Memcache (or anything similar) presently, though I do believe we looked at it sometime last year. Will get a re-check done on this - thanks. :)

[ks → webvet]

You should look into caching. If you are talking about webvet.com it looks like a perfect site for using something like Varnish. Most of the content probably doesn't change often so you should be able to have a long TTL.