<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Stephan Richter wrote:
<blockquote cite="mid:200807241020.59864.srichter@cosmos.phy.tufts.edu"
type="cite">
<pre wrap="">On Thursday 24 July 2008, Shane Hathaway wrote:
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">P.S.: I am quite excited about the memcached support. Does it "just
work"? I.e. can I run my ZODB in RAM now? ;-)
</pre>
</blockquote>
<pre wrap="">I expect the new memcache support to be safe for everyone to use, but we
still require the main database to be connected at all times, since
memcache provides no ACID properties by itself. We unfortunately can't
do obvious things like cache the current transaction ID for an object,
since that would break MVCC. What we do cache is:
1. The current tid, given an oid and the transaction ID that is active
for the current connection.
2. The pickle given an oid and tid.
These should both help read-heavy databases, but might be detrimental
for write-heavy databases. My performance test suite, which writes a
lot, produced slightly *worse* results with memcache enabled.
</pre>
</blockquote>
<pre wrap=""><!---->
We should get Brian Aker into this discussion, since is one of the main
architects of MySQL and one of the founders of memcached.
As Shane knows, I have some access to Brian these days, so we could have an
online meeting talking about it.
</pre>
</blockquote>
<br>
Well, if I can make a suggestion :)<br>
<br>
>From what I understand a new memcache client library was written for
MySQL (libmemcache is quite horrible). Python bindings for that library
would improve many things, including this :)<br>
<br>
Wichert.<br>
<br>
<pre class="moz-signature" cols="72">--
Wichert Akkerman <a class="moz-txt-link-rfc2396E" href="mailto:wichert@wiggy.net"><wichert@wiggy.net></a> It is simple to make things.
<a class="moz-txt-link-freetext" href="http://www.wiggy.net/">http://www.wiggy.net/</a> It is hard to make things simple.
</pre>
</body>
</html>