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@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