[Zope] BerkeleyDB slow

matt matt@virtualspectator.com
Thu, 1 Nov 2001 20:07:22 +1300


This is a multi-part message in MIME format.

------=_NextPart_000_00A6_01C16310.D144AD10
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I am finding that writes to the ZODB are far slower when the storage is =
BerkeleyDB instead of Data.fs.  I should also mention that I run this =
through ZEO, if that has anything to do with it.  I now have quite a few =
folders, some with up to 1000 objects in them.  I know ZEO is not very =
write friendly, but if I switch the Storage back to main .. i.e. =
Data.fs(Still as a zeo client), and import data into it, then I find it =
is 5-10 times faster when doing something as simple as editing small =
dtml method.

My current system is the following :

      Zope Version  (Zope 2.4.0 (source release, python 2.1, linux2), =
python 2.1.0, freebsd4) =20
      Python Version  2.1 (#1, Jul 18 2001, 17:06:28) [GCC 2.95.3 =
[FreeBSD] 20010315 (release)] =20
      System Platform  freebsd4 =20


I was wondering if this behaviour was common.

regards
Matt



------=_NextPart_000_00A6_01C16310.D144AD10
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I am finding that writes to the ZODB =
are far slower=20
when the storage is BerkeleyDB instead of Data.fs.&nbsp; I should also =
mention=20
that I run this through ZEO, if that has anything to do with it.&nbsp; I =
now=20
have quite a few folders, some with up to 1000 objects in them.&nbsp; I =
know ZEO=20
is not very write friendly, but if I switch the Storage back to main .. =
i.e.=20
Data.fs(Still as a zeo client), and import data into it, then I find it =
is 5-10=20
times faster when doing something as simple as editing small dtml=20
method.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>My current system is the following =
:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>
<TABLE cellSpacing=3D0 cellPadding=3D2 border=3D0>
  <TBODY>
  <TR>
    <TD vAlign=3Dtop align=3Dleft>
      <DIV class=3Dform-label>Zope Version </DIV></TD>
    <TD vAlign=3Dtop align=3Dleft>
      <DIV class=3Dform-text>(Zope 2.4.0 (source release, python 2.1, =
linux2),=20
      python 2.1.0, freebsd4) </DIV></TD></TR>
  <TR>
    <TD vAlign=3Dtop align=3Dleft>
      <DIV class=3Dform-label>Python Version </DIV></TD>
    <TD vAlign=3Dtop align=3Dleft>
      <DIV class=3Dform-text>2.1 (#1, Jul 18 2001, 17:06:28) [GCC 2.95.3 =
[FreeBSD]=20
      20010315 (release)] </DIV></TD></TR>
  <TR>
    <TD vAlign=3Dtop align=3Dleft>
      <DIV class=3Dform-label>System Platform </DIV></TD>
    <TD vAlign=3Dtop align=3Dleft>
      <DIV class=3Dform-text>freebsd4 =
</DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I was wondering if this behaviour was=20
common.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Matt</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_00A6_01C16310.D144AD10--