[Zope-DB] Re: Typical size of result sets

Charlie Clark charlie at egenix.com
Wed Jan 19 05:33:31 EST 2005


On 2005-01-19 at 10:41:27 [+0100], Chris Withers <chris at simplistix.co.uk> 
wrote:
> Charlie Clark wrote:
> >>Wow, I've never seen this before in my life :-)
> >>
> >>How does it relate to ZSQL methods?
> > 
> > Easy: going away from <dtml-sqlvar> to some kind of positional parameter
> > brings immense performance improvements (40% on non-cached queries).
> 
> There have bene lots of discussions about this. Sadly, backwards
> compatability means it's probably not worth fighting abotu for Zope 2.
> 
> Zope 3 is still nice virgin territory though!

Zope 2 is still in production in lots of sites and is likely to remain so. 
posSQL will be released as a separate product as it will do more than just 
use positional parameters.

Charlie


More information about the Zope-DB mailing list