Re: Finding total Rows without count() ?

<mgoelz_at_efn.org> wrote in message news:385956DA.6125C01F_at_efn.org...
> Obviously , %rowcount would not return full count until after last fetch and before
> close. The point was that this may still be faster than count(*) on a very large table.

No. Absolutely not.

Try to identify how many CPU time and memory will be exhausted if you fetch out millions of rows just in order to get one number value. Received on Sat Dec 18 1999 - 09:54:50 CST