RE: [Zope-dev] Threaded Database Access
Thanks for the info guys. It looks like these might do the trick. -Original Message- From: Paul Browning [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 10:55 AM To: Casey Duncan Cc: Jeff Nielsen / UgoFast; zope-dev Subject: Re: [Zope-dev] Threaded Database Access --On 02 May 2002 10:08 -0400 Casey Duncan <[EMAIL PROTECTED]> wrote: > ZPsycopgDA (for postgres) is definitely multi-threaded. I think > zPopyDA is too. http://www.zope.org/Members/glpb/solaris says: > The report also investigates in a cursory way the effects of adding a > database adapter to the equation. A test was carried out to compare > the effect of changing the threading model on a site doing queries > against an Oracle database using DCOracle2. It was found that queries > that involved writes on the database were forced to be completed in > serial (this is unsuprising), whilst read requests could be carried > out in parallel. In addition, ZSQL Methods have the ability to cache > the rows they fetch from a database for a given query. The results > show that caching of SQL queries can produce a significant performance > boost. HTH Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: [EMAIL PROTECTED] URL: http://www.bris.ac.uk/ ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Threaded Database Access
I'm using Zope/Zserver 2.2.4, ZODBCDA v3.1.0b2 and SQL Server 2000. I've noticed that pages generated from database querries are definitely single threaded, and these pages are the bulk of my site. My poking around seems to indicate that ZODBCDA is the single-threaded culprit, and some emails from the list over the last couple months seem to confirm that. The volume of my site and the size of the database (hence query response times) are getting to the point that this is a concern. So I'm investigating my options, including: 1) Cluster the web site with multiple single processor machines. 2) Move to a database that Zope supports multi-threaded access to. 3) ? I've been considering a move to Oracle or PostgreSQL/MySQL for other reasons, but I'm not going to do it just for yucks. Extending and populating my site gives better return than porting the database. I'd like to make sure I'll get return on my time investment. I saw an document on the Zope web site from 1999 that talked about labeling Zope DAs Level 1,2 or 3 based on their sophistication, but I don't see any of the current DAs labeled as such. There was text in the Oracle and MySQL DA descriptions that seem to imply multi-threaded behaivor though. I'm looking for the info from the community on: 1. Is the ZODBCDA single-threaded and might that change anytime soon? 2. Can someone confirm that the Oracle, PostgreSQL or MySQL DAs are multi-threaded. 3. Does the multi-threading require using the Zope Session facility or some other feature? (My site uses FSSession.) Thanks in advance for any input. Jeff Nielsen / UgoFast http://www.UgoFast.com [EMAIL PROTECTED] ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
RE: [Zope-dev] Create directory in LocalFS
Dieter, I don't think I'm understanding you. I want to create the subdirectory programmitcally inside a DTML Document. Are you suggesting something like: or (Neither one works. I tried them.) Do I need a more recent version of LocalFS? I'm using v0.9.6 (I think). It doesn't appear that v0.10.1 addressed this kind of thing. Jeff -Original Message- From: Dieter Maurer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:29 PM To: Jeff Nielsen / UgoFast Cc: [EMAIL PROTECTED] Subject: Re: [Zope-dev] Create directory in LocalFS Jeff Nielsen / UgoFast writes: > Can anyone tell me how to create a subdirectory programmatically under a > LocalFS folder? I have a LocalFS folder called images. When I add a new > promoter to my site, I'd like to automatically add a directory that > would hold that promoter's images. If the promoter's ID number is 187, I > want to create a subdirectory '187' under images/Companies/100. Can you do it in ZMI? If yes, look at its code. It does it programmatically! Dieter ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Create directory in LocalFS
Can anyone tell me how to create a subdirectory programmatically under a LocalFS folder? I have a LocalFS folder called images. When I add a new promoter to my site, I'd like to automatically add a directory that would hold that promoter's images. If the promoter's ID number is 187, I want to create a subdirectory '187' under images/Companies/100. Jeff Nielsen / UgoFast http://www.UgoFast.com [EMAIL PROTECTED] ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
RE: [Zope-dev] A simple dtml-if question...
Hey thanks. That works. -Original Message- From: Chris Withers [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 4:43 AM To: Jeff Nielsen / UgoFast Cc: Christian Theune; Zope-Dev@Zope. Org Subject: Re: [Zope-dev] A simple dtml-if question... > Thanks Christian, but it didn't work. I went with the long way: > > > > Valid response > > False response > > > False response > Valid Response Fasle Response cheers, Chris ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
RE: [Zope-dev] A simple dtml-if question...
Thanks Eric, I tried it and it didn't work. I went with the long way: Valid response False response False response Jeff -Original Message- From: E. Seifert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 2:02 AM To: Jeff Nielsen / UgoFast Cc: [EMAIL PROTECTED] Subject: Re: [Zope-dev] A simple dtml-if question... Hi Jeff, Jeff Nielsen wrote: > How do I construct a dtml-if statement with two conditions joined by "and" > logic? I want to do something like this: > > Did you try Regards Eric ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
RE: [Zope-dev] A simple dtml-if question...
Thanks Christian, but it didn't work. I went with the long way: Valid response False response False response Jeff -Original Message- From: Christian Theune [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 1:05 AM To: Jeff Nielsen / UgoFast Subject: Re: [Zope-dev] A simple dtml-if question... > > > hmm ... just guessing: Think so: It has to be a complete boolean expression .. so try to combine boolean operators ... Tell me if it worked ... :) -- Christian Theune - [EMAIL PROTECTED] gocept gmbh & co.kg - schalaunische strasse 6 - 06366 koethen/anhalt tel.+49 3496 3099112 - fax.+49 3496 3099118 mob. - 0178 48 33 981 reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b'))) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] A simple dtml-if question...
How do I construct a dtml-if statement with two conditions joined by "and" logic? I want to do something like this: Jeff Nielsen / UgoFast http://www.UgoFast.com [EMAIL PROTECTED] ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )