[Zope-DB] Typical size of result sets

Chris Withers chris at simplistix.co.uk
Tue Jan 18 13:46:32 EST 2005


Charlie Clark wrote:
>>>I'd stick in a bug in the collector. It should be fairly trivial to add
>>>some documentation to the form explaining what's going on.
>>>
>>>What about changing the default to 0 while we're at it?
>>
>>That would be my preference as well. The fact that Z SQL Methods
>>default to returning at most 1000 rows is not well documented
>>and also well hidden in the Z SQL Method user interface.
>>
>>People will likely not know about it and then get strange
>>results when doing queries on large database tables.
> 
> Yep, must be right up there in newbies questions and once you know about it 
> you kind of forget about it. Would probably be useful to see and set the 
> value in the main page rather than "advanced". I think I will do this in 
> posZSQL-Methods.

Well, I look forward to seeing the collector entry appear :-)

> BTW. re positional (qmark) parameters, it seems that not every Python 
> driver actually supports them. Does anyone know if they're favourite 
> Zope-DA's underlying driver supports them?

What's a qmark parameter?

Chris

-- 
Simplistix - Content Management, Zope & Python Consulting
            - http://www.simplistix.co.uk


More information about the Zope-DB mailing list