[Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?
chris at simplistix.co.uk
Fri Dec 2 04:33:34 EST 2005
Charlie Clark wrote:
>>That doesn't work if you use offsets and limits to only return part of a
> SELECT count(attribute) FROM relatiin WHERE condition
Ah, okay, now I gotcha...
> only returns 1 result so it's independent of LIMIT and result sets.
I wonder how the two methods compare efficiency-wise?
> Of course, ZopeDAs such as our mxODBCZopeDA can be extended to support
> additional commands on the connection but that is not part of the ZSQL
> specification and will vary from RDBMS to RDBMS as the initial mail noted.
Well, that's why MySQL does it as an SQL statement, no? ;-)
Simplistix - Content Management, Zope & Python Consulting
More information about the Zope-DB