[Zope-DB] BerkeleyDB slow
matt
matt@virtualspectator.com
Thu, 1 Nov 2001 21:55:39 +1300
This is a multi-part message in MIME format.
------=_NextPart_000_00F7_01C1631F.F1919330
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Chris Withers pointed me here to find an answer. The following is a =
copy of the emails from the main zope mailing list.
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
________
Reply from Chris Withers
Indeed. It's two to five times slower.
Ask Barry why (->zodb-dev@zope.org)
cheers
Chris
__________________________
------=_NextPart_000_00F7_01C1631F.F1919330
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>Chris Withers pointed me here to find =
an=20
answer. The following is a copy of the emails from the main zope =
mailing=20
list.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </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. I should also =
mention=20
that I run this through ZEO, if that has anything to do with it. I =
now=20
have quite a few folders, some with up to 1000 objects in them. 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> </DIV>
<DIV><FONT face=3DArial size=3D2>My current system is the following =
:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </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> </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> </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> </DIV>
<DIV><FONT face=3DArial size=3D2>________</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Reply from Chris Withers</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT><BR>Indeed. It's two to five =
times=20
slower.<BR><BR>Ask Barry why=20
(->zodb-dev@zope.org)<BR><BR>cheers<BR><BR>Chris<BR></DIV>
<DIV><FONT face=3DArial size=3D2>__________________________</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></DIV></BODY></HTML>
------=_NextPart_000_00F7_01C1631F.F1919330--