[Zope] Python use more and more memory

[Terry]

Thanks to the list,

I think I found the stupid thing I did.

Because I replace the "Maximum rows to retrieve"  of a ZSQL Method by 
"0", sometimes there are 1??,??? rows return from the Database.
Then even hang my Database.

Thanks to everyone.

Felix Ulrich-Oltean wrote:

>On Wed, Dec 11, 2002 at 09:27:07AM -0500, ken wrote:
>  
>
>>Dieter Maurer at 20:18 (UTC+0100) on Tue, 10 Dec 2002 said:
>>= Terry writes:
>>=  > In beginning I start Zope.
>>=  > the python use about 26M memory.
>>=  > 
>>=  > After several hours
>>=  > get the result by "top"
>>=  > Sort by memory usage
>>=  > 
>>=  > PID  USER    PRI NI  SIZE RSS SHARE STAT %CPU %MEM  TIME COMMAND
>>=  > 4931 www-data 13  0 94324 92M 2504     S  3.5 10.4  7:43 python
>>=  > 5022 www-data  9  0 94324 92M 2504     S  0.0 10.4  0:00 python
>>=  > 5023 www-data  9  0 94324 92M 2504     S  0.0 10.4 15:55 python
>>=  > 5024 www-data 14  0 94324 92M 2504     S 14.5 10.4 16:55 python
>>=  > 5025 www-data 10  0 94324 92M 2504     S  0.3 10.4 15:35 python
>>=  > 5026 www-data  9  0 94324 92M 2504     S  0.0 10.4 16:32 python
>>=  > 
>>=  > Have any idea why?
>>
>>For easier reading, I inserted spaces in the above top output.  Hope 
>>this didn't mess it up for someone else.
>>    
>>
>
>That's much prettier.
>
>  
>
>>Maybe I'm missing something, but I see the %MEM staying at 10.4; SHARE 
>>and SIZE are likewise staying the same.  Seems that it's behaving itself 
>>quite well.  Or...?
>>    
>>
>
>I think the listing is a snapshot at one time - the lines are the
>different threads and the memory figures are in fact shared memory.
>The percentage is 10.4, but the actual size is 94M, which compared to
>26M at the beginning is a sizeable increase.
>
>Felix.
>
>_______________________________________________
>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 )
>
>
>  
>