<br><br><div class="gmail_quote">On Mon, Apr 5, 2010 at 5:31 PM, Rob Nagler <span dir="ltr"><<a href="mailto:nagler@bivio.biz">nagler@bivio.biz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
We are having some performance issues for some of our larger apps. We<br>
have a Postgres table (Bivio::Biz::Model::RealmRole) which needs to<br>
get access frequently, and is written relatively infrequently. We<br>
need some sort of in memory cache.<br>
<br>
I took a look at the IPC::* modules, and none of them seems so<br>
brilliant. Before I go diving into performance testing each of them,<br>
I was wondering if anybody on this list had opinions about which is<br>
the most reliable.<br>
<br>
We need to get to <100ms for accessing the data, which for our larger<br>
apps, is about 500KB serialized with Data::Dumper. Deserialization is<br>
too expensive (250ms).<br>
<br>
We are also thinking about going with a *dbm module or perhaps<br>
Berkeley DB. There are about 800K rows, which is really a two-level<br>
tree (realm, role), which is why the serialization is so compact. I<br>
don't know how dbm/DB work with this size of data.<br>
<br>
So I'm looking for experience with these technologies from a<br>
reliability (first) and performance (second) standpoint.<br>
<br>
Thanks,<br>
Rob<br>
<br>
_______________________________________________<br>
Boulder-pm mailing list<br>
<a href="mailto:Boulder-pm@pm.org">Boulder-pm@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/boulder-pm" target="_blank">http://mail.pm.org/mailman/listinfo/boulder-pm</a><br>
</blockquote></div><br>What are you hitting the db with? Are you using an orm? straight dbi? etc. <div><br></div><div><br clear="all"><br>-- <br>Devin Austin<br><a href="http://www.codedright.net">http://www.codedright.net</a><br>
9702906669 - Cell<br>
</div>