[egenix-users] cursor.rowcount abnormalities and performance question

[Michal Vitecek]

M.-A. Lemburg wrote:
>If cursor.execute('SELECT @@ROWCOUNT') works on all MS Server
>versions out there, no problem. But if it's really that easy to
>fetch the value I wonder why MS didn't put the same logic into
>their ODBC drivers... I presume that this operation is
>rather costly.

 they took the logic from Sybase ASE which does some things quite
 differently from other relational databases. however @@rowcount is a
 variable that is local to a connection so imho reading from it won't be
 that expensive. a benchmark should be the decisive thing. 

-- 
		fuf		(fuf at mageo.cz)