Writing to a database is one of the most resource intensive things you can do. My understanding is that reading is about half of what writing is. Some databases have been optimized for one or the other and a good example is LDAP which is very fast at reading, but slow at writing (thusly good at username and passwords). For ZODB there becomes a point where the complexity and overhead of the RDBMS are less than writing to the ZODB which has greater limitations in size and overall flexibility. There are also huge issues in terms of keeping multiple SQL databases synced up so there is a case to be made to spread ZEO across many webservers with one beefy DB server in the background serving them. That, combined with Zope's ability to cache creates a highly scalable solution (IMHO). I, personally, am just salivating at the chance to get my hands on ZEO. J
From: "Jason Spisak" <444@hiretechs.com> Date: Thu, 27 Apr 2000 15:25:14 GMT To: Sam Gendler <sgendler@silcom.com> Cc: zope@zope.org Subject: Re: [Zope] Zope's scalability across multiple web servers
Sam Gendler writes:
However, if you are dynamically creating objects in the ZODB (something that is strobly discouraged in a high volume write situation)
Why is that? I thought the connection overhead and maintainence of a RDBMS was a big deal? This gets brought up a lot. And I like to hear opinions. I am aware that whatever justification is given is purely about what works for you, but I'd love to hear the reasoning.
All my best,
Jason Spisak CIO HireTechs.com 6151 West Century Boulevard Suite 900 Los Angeles, CA 90045 P. 310.665.3444 F. 310.665.3544
Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )