<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV>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?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>While Memcached can be used for row-level caching, it is ideally suited for caching in the Model layer of an MVC application.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>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.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Randy</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR><DIV><DIV>On Jun 25, 2007, at 8:33 AM, Cal Heldenbrand wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; ">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<SPAN class="Apple-converted-space"> </SPAN><SPAN style="font-weight: bold;"><SPAN class="Apple-style-span" style="font-weight: bold; ">much</SPAN></SPAN><SPAN class="Apple-converted-space"> </SPAN>more attractive.</SPAN></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>