Re: Count(*) is very slow

Hallo everybody,

I've got a mail with the right idea from Dave Smith from Australia.

The trick to do 'SELECT COUNT(*) FROM ATABLE' fast is, to include:

    fast_full_scan_enabled=true
to the init file.

That's all and now it takes less than a second. 8-))

Thanks to all posted their suggestions and hints

--
Andreas Kyritz
AKyritz_at_easy-soft-dresden.de Received on Thu Oct 22 1998 - 04:46:45 CDT