Seems like this is a pretty common question on the mailing list. Are you guys going to throw a HOWTO / Wiki out there anytime soon? Maybe it'd save a lot of usage questions, and probably be a more thorough answer for everyone?
<br><br>I'm no different though, I'm still on the next phase of planning memcache integration. It's definitely a challenge to try and map an RDMS to a hash environment. They don't really jibba-jabba well together. 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 style="font-weight: bold;">much</span> more attractive.<br><br>In light of the FUSE conversations earlier, I had the thought of maybe ripping out the backend on <a href="http://www.sqlite.org/arch.html">SQLite</a> and hooking it into memcache. That, or since SQLite uses plain ol' flat files, using the FUSE mounted filesystem as the middle layer between SQLite and memcache, which results in a nice little SQL interface to the caching system. That makes it just a few little baby steps on implementing an implicit caching environment. (With the cost of added layers, and most likely a space-hungry usage of memcache vs. doing it manually)
<br><br>What do you guys think?<br><br>--Cal<br><br><div><span class="gmail_quote">On 6/23/07, <b class="gmail_sendername">Brian Moon</b> <<a href="mailto:brianm@dealnews.com">brianm@dealnews.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Chris Miller wrote:<br>> My question is simple: How can memcached help me?<br><br>My response got kind of long, so I just put it in a blog post. Its<br>similar to what others have said.<br><br><a href="http://doughboy.wordpress.com/2007/06/23/caching-and-patience/">
http://doughboy.wordpress.com/2007/06/23/caching-and-patience/</a><br><br>--<br><br>Brian Moon<br>Senior Developer<br>------------------------------<br><a href="http://dealnews.com/">http://dealnews.com/</a><br>It's good to be cheap =)
<br></blockquote></div><br><br clear="all"><br>