Re: [Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?

2005-12-05 Thread Chris Withers
Charlie Clark wrote: 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? Yes, well, we're talking about MySQL specifically ;-) Maybe altho

Re: [Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?

2005-12-05 Thread Charlie Clark
On 2005-12-05 at 08:42:09 [+0100], Chris Withers <[EMAIL PROTECTED]> wrote: > Charlie Clark wrote: > >>>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