Re: ZODB eating CPU but RAM is free

------=_Part_1476_359909991.1545058678441
Content-Type: multipart/alternative; 
	boundary="----=_Part_1477_753021766.1545058678441"

------=_Part_1477_753021766.1545058678441
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Monday, December 17, 2018 at 6:09:45 AM UTC-8, Jim Fulton wrote:
>
>
> By "finalized" I meant the connection is still open but no more=20
>> transactions are being commited, so the database is used only for reads.
>>
>
> Reads are executed in transactions. In fact, most transactions are read=
=20
> transactions.
>

Good to know, thanks.
=20

>
>
>> I think I can confirm my initial assumption from your answer though =E2=
=80=94 the=20
>> target cache size configuration is not going to be applied automatically=
 in=20
>> this scenario, and I'll have to free database cache manually by caling=
=20
>> cacheMinimize().
>>
>
> Cache  management is applied at transaction boundaries. You can and=20
> generally should commit periodically when reading. If you don't, you won'=
t=20
> see updates from other users or processes.=20
>

I know for a fact no other user or process writes to (or reads from, for=20
what it matters) the database. Would you still suggest me to commit when=20
reading, as opposed to calling cacheMinimize instead?

--=20
You received this message because you are subscribed to the Google Groups "=
zodb" group.
To unsubscribe from this group and stop receiving emails from it, send an e=
mail to [email protected].
For more options, visit https://groups.google.com/d/optout.

------=_Part_1477_753021766.1545058678441
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">On Monday, December 17, 2018 at 6:09:45 AM UTC-8, Jim Fult=
on wrote:<blockquote class=3D"gmail_quote" style=3D"margin: 0;margin-left: =
0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;"><div dir=3D"auto"><di=
v><br><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D=
"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D=
"ltr"><div>By &quot;finalized&quot; I meant the connection is still open bu=
t no more transactions are being commited, so the database is used only for=
 reads.</div></div></blockquote></div></div><div dir=3D"auto"><br></div><di=
v dir=3D"auto">Reads are executed in transactions. In fact, most transactio=
ns are read transactions.</div></div></blockquote><div><br></div><div>Good =
to know, thanks.<br></div><div>=C2=A0</div><blockquote class=3D"gmail_quote=
" style=3D"margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding=
-left: 1ex;"><div dir=3D"auto"><div dir=3D"auto"></div><div dir=3D"auto"><b=
r></div><div dir=3D"auto"><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex"><div dir=3D"ltr"><div><br></div><div>I think I can confirm my init=
ial assumption from your answer though =E2=80=94 the target cache size conf=
iguration is not going to be applied automatically in this scenario, and I&=
#39;ll have to free database cache manually by caling cacheMinimize().<br><=
/div></div></blockquote></div></div><div dir=3D"auto"><br></div><div dir=3D=
"auto">Cache=C2=A0 management is applied at transaction boundaries. You can=
 and generally should commit periodically when reading. If you don&#39;t, y=
ou won&#39;t see updates from other users or processes. <br></div></div></b=
lockquote><div><br></div><div>I know for a fact no other user or process wr=
ites to (or reads from, for what it matters) the database. Would you still =
suggest me to commit when reading, as opposed to calling cacheMinimize inst=
ead?<br></div></div>

<p></p>

-- <br />
You received this message because you are subscribed to the Google Groups &=
quot;zodb&quot; group.<br />
To unsubscribe from this group and stop receiving emails from it, send an e=
mail to <a href=3D"mailto:[email protected]">zodb+unsubscri=
[email protected]</a>.<br />
For more options, visit <a href=3D"https://groups.google.com/d/optout">http=
s://groups.google.com/d/optout</a>.<br />

------=_Part_1477_753021766.1545058678441--

------=_Part_1476_359909991.1545058678441--