Re: What's fast way to get total of records

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Wed, 8 Oct 2003 16:18:34 +0200
Message-ID: <1065622230.119307@news.thyssen.com>

"Billy Verreynne" wrote...
(snip)
> So,
>
> Step 1. Realise that SELECT count(*) itself is not the problem.
> Step 3. Determine the factors that causes the SELECT count(*) to be
> slow.
> Step 5. Address those factors.
>
> Steps 2 and 4? They are reserved for the consumption and enjoyment
of
> vast amounts of coffee.
>
>
> --
> Billy

Hi Billy,

thanks for this excellent guide. I managed to follow steps 2 and 4. Maybe one day I'll try the odd ones too ;-).

Off for holidays,
Guido Received on Wed Oct 08 2003 - 09:18:34 CDT