> > I know Count(*) requires a full scan and can't return immedialtely. But
> > isn't 8 minutes a bit too much for a 50 millions rows table ?
>
> This is about 100.000 records per second - what kind of speed were you
> expecting?

Presented like this, it seems obvious. ;-)

But I am used to smaller dbs, and the first time you have to wait 8 minutes
just because you told yourself "Oh BTW, how many records are in there ?", it
feels strange. Well that was the first time...
I won't be that impatient as of now. Better schedule my stats nightly and
watch
reports in the morning.

Regards.

--
Jerome