How abstracted are those 230 tables from the millions of lines of
code? Are you using an ORM or is everything explicitly tied to the
underlying schema?
While Memcached can be used for row-level caching, it is ideally
suited for caching in the Model layer of an MVC application.
One approach might be to identify a small number (< 5) of areas in
your code that would most directly benefit from caching, and
implement a first pass there. Once that’s working and you’re more
familiar with Memcached, look into a more comprehensive solution.
Randy
On Jun 25, 2007, at 8:33 AM, Cal Heldenbrand wrote:
You have to one-by-one implement a separate variable storage after
pulling from the database with a specific query, or implement some
layer on top of memcache to try and do some of the logic for you.
We have 230 tables and millions of lines of code, the latter seems
much more attractive.
