[Zope] [GENERAL] PyGres DB Connection in Zope drops when many Users are added (UserDB) (UserDB)

[J. Atwood]

AB is apachebench which is a benchmarking program. You can basically 
pound on your installation to see where the weaknesses (slowness) is. 
For you, this could mean just a few Methods that have the SQL in them 
or the SQL Methods themselves.  Watch them in top (in Linux) and see 
what happens.

Caching is part of the PyGreSQL method (the advanced tab).

Sorry about the 6.5.3, I thought I read 7.

J


At 8:06 AM -0500 4/25/2000, Stephan Richter wrote:
>At 06:21 AM 4/25/00 -0400, J. Atwood wrote:
>>Have you tried running AB against some of the pages and watching 
>>the connections happen? Also, try playing around with the cache. I 
>>found that I could change the load times and db performance by 
>>playing with Zope db caching.  I would also hate to mention it but 
>>7 is still beta. Can you try it on 6.5.3 and see if it still 
>>happens?
>
>I am sorry, I should have mentioned: It originally occurred with 
>PostGres 6.5.3.
>What is AB? If everything fails, I will try the caching options. I 
>just do not want to introduce new variables to the game.
>
>Regards,
>Stephan
>--
>Stephan Richter - (901) 573-3308 - srichter@cbu.edu
>CBU - Physics & Chemistry; Framework Web - Web Design & Development
>PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391