[Zope] DCOracle2 slow - what could be the reason?

[Matt Hamilton]

> Hi all,
>
> we have just encountered a bad problem with DCOracle2 performance on
large querys compared to anything else. While 40,000 row query done on
Perl takes about 1 second - takes it via DCORacle2 on Python more than
20 seconds.

I know Chris Withers has done some specific work on the internals of
DCOracle2 so may be able to help further.... however is it a performance
issue with DCOracle2 itself, or is it more to do with SQL result sets in
Zope?  Displaying/sorting a 40,000 row SQL result set in ZPT, say, is very
expensive.  What are you doing to the returned result set in your test?

-Matt

-- 
Matt Hamilton                                         matth at netsight.co.uk
Netsight Internet Solutions, Ltd.          Business Vision on the Internet
http://www.netsight.co.uk                               +44 (0)117 9090901
Web Design | Zope/Plone Development and Consulting | Co-location | Hosting