[Zope-dev] Re: any limits on object number?

2004-07-19 Thread Dorneles Treméa
Hello all, thanks to all the responses. I will test with BTreeFolder2, and subfoldering with first character of id as another subfolder2, so that working with ZMI will also be possible without further scripting or customized views. i will report the results back to the list. just an additional

Re: [Zope-dev] Making a ZSQL.DA fully multi-threaded?

2004-07-19 Thread Chris Withers
Brad Clements wrote: What's the actual problem you're experiencing? I have set the SAPDB timeout to 32400 seconds. Unless you have an extremely heavily loaded Zope, that's too low, and may be causing you problems... Chris -- Simplistix - Content Management, Zope Python Consulting -

Re: [Zope-dev] Making a ZSQL.DA fully multi-threaded?

2004-07-19 Thread Chris Withers
Brad Clements wrote: That does suck, but it doesn't seem like an insurmountable problem for a DA. You just need a per-DA instance mutex which you acquire before opening a connection release afterwards. Someone else said that every thread has it's own copy of ZODB, hence their own copies of each

Re: [Zope-dev] Making a ZSQL.DA fully multi-threaded?

2004-07-19 Thread Chris Withers
Ganesha Shanmuganathan wrote: parallel because of the overhead of setting up new connections. To implement connection pooling, I think it is best to do it using an externel product like SQLRelay than at the driver level. You may find connecting to SQLRelay suffers from the same problems... It's

Re: [Zope-dev] Re: any limits on object number?

2004-07-19 Thread Nagarjuna G.
On Mon, 2004-07-19 at 11:38, Dorneles Trema wrote: Resuming what I've learned: don't abuse of BTreeFolder, hash your content and live happy forever... ;-) PS: The server is a modest PIII 1.2GHz, 1GB RAM with a 160MB/s SCSI controller running only one instance of Zope 2.7.1 without ZEO.

[Zope-dev] Re: any limits on object number?

2004-07-19 Thread Dorneles Treméa
Hi Nagarjuna, Thanks a lot. Your report that performance enhances due to hashing is encouraging the decision we took. In our case we already began using BTreeFolder2, havent tried creating the large object base yet (will do this week), but we doing something like what you did. we are creating

Re: [Zope-dev] Making a ZSQL.DA fully multi-threaded?

2004-07-19 Thread Brad Clements
On 19 Jul 2004 at 7:44, Chris Withers wrote: Brad Clements wrote: What's the actual problem you're experiencing? I have set the SAPDB timeout to 32400 seconds. Unless you have an extremely heavily loaded Zope, that's too low, and may be causing you problems... That is the maximum

Re: [Zope-dev] Re: any limits on object number?

2004-07-19 Thread Jens Vagelpohl
Even using BTreeFolder to store all objects I was getting 300s delay to show a single object (ok, it's an archetypes-based one, containing 50 fields, splitted into 7 schematas, with lots of fancy stuff...). So I made a directory hash structure based on UID from each object (an AT UID is md5, so we

Re: [Zope-dev] Re: any limits on object number?

2004-07-19 Thread Florent Guillaume
thanks to all the responses. I will test with BTreeFolder2, and subfoldering with first character of id as another subfolder2, so that working with ZMI will also be possible without further scripting or customized views. i will report the results back to the list. just an additional

[Zope-dev] UnpickleableError using SESSION in 2.7.2RC1

2004-07-19 Thread Brad Clements
Can sessions store instance objects created by an external method? I'm running Python 2.3.4 (also happens with 2.3.2) I also get this error with Zope 2.7.0 I'm trying to save a simple instance in a session. The instance is created in an external method. I can't figure out why I get this error

[Zope-dev] Troubles with hotfix20040714

2004-07-19 Thread C. Olmsted
Hi All, Not sure if this is quite the correct list to post to, but I'm having trouble with Hotfix20040714. We're running zope 2.7, plone 2.0.3, and zwiki 0.32.0. The specific error appears to be the same one that cropped up with the previous hotfix (20040713): METALError: macro

[Zope-dev] APE and .svn folders, broke ZMI

2004-07-19 Thread Brad Clements
Hi, I've run into a problem with Ape and I cannot determine if it's caused by a change in Python version, Zope version or Ape version. I have this problem with Ape 0.71, 0.8, and 0.81 And, Zope 2.7.1 and 2.7.2RC1 and Python 2.3.4 Basically, I use subversion to control my file-system files,

Re: [Zope-dev] Troubles with hotfix20040714

2004-07-19 Thread Fred Drake
On Mon, 19 Jul 2004 09:48:00 -0700 (PDT), C. Olmsted [EMAIL PROTECTED] wrote: Not sure if this is quite the correct list to post to, but I'm having trouble with Hotfix20040714. We're running zope 2.7, plone 2.0.3, and zwiki 0.32.0. Can you test with the 2.7.2 release candidate? This very