[Zope-DB] Re: Example for RDB persistency in zope products?

[Nick Bower]

Ok I'll keep that in mind.  Maybe as Charlie said, it has to do with ZEO 
and I need to benchmark against ZEO and non-ZEO.

I'll definitely look at the Zope Profiler thanks - last time I applied 
basic python profiling to Zope, it wouldn't go down into the Product 
level, which is where I needed to be looking.

Nick

Dieter Maurer wrote:
> Nick Bower wrote at 2004-6-26 12:07 +0200:
> 
>>Thanks, but part of the reason I was wanting to avoid ZSQL is because 
>>(for whatever reason) I've been unable to get any decent performance 
>>using TTW+ZSQL components in a ZEO environment.  ZPT benchmarks fine, 
>>but add some ZSQL and you're hosed!
> 
> 
> That is surprising:
> 
>   The Z SQL Method layer is quite thin.
> 
>   I doubt that you will gain much performance when you directly access the
>   database connection.
> 
> I suggest you make an execution profile to analyse what is the
> main bottleneck. My "ZopeProfiler" may help:
> 
>   <http://www.dieter.handshake.de/pyprojects/zope>
> 
> 
> 
>