[Zope-DB] DCOracleStorage multiple DB connections?

[Matthew T. Kromer]

Randy Jay Yarger wrote:

>Howdy,
>
>Does anyone know if DCOracleStorage is supposed to, or can, use multiple
>simultaneous connections to Oracle? From DB.py it seems that Zope itself
>is supposed to use up to 7 Oracle connections, but on my rather loaded
>site, I'm only seeing one. This generally isn't a problem, but when
>someone hits something large, such as a folder listing with 10k plus
>items in it through /manage, it freezes up the site for everyone until
>it's done.
>
>On the positive side, DCOracleStorage and Zope in general, has been a
>great win here. My company (Web Elite (www.webelite.com)) just launched
>a public site and an intranet for Washtenaw County, Michigan (home of
>Ann Arbor and the University of Michigan). Zope won out for the CMS over
>the usuals (Interwoven, Vignette, etc.) and except for this performance
>problem has been a big hit!
>
>Thanks!
>-Randy Yarger
>ryarger@webelite.com
>
>  
>

HI Randy,

Glad you're having success with DCOracleStorage!

Make sure you're running with the cost based optimizer not the rule 
based optimizer, that will help your performance a lot.

You'll only see one DB connection used; Zope is still serializing the 
connection to the database just like it seralizes the connection to 
FileStorage.

If you use a folder with a lot of items, switch the folder type to a 
BTreeFolder, that will speed it up a lot.