Re: CPU waiting for... what? (mistery)

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Fri, 11 Apr 2003 22:32:35 +0200
Message-ID: <tg8e9vgvpfm0vm8r64lfo143onbeh9q8nl@4ax.com>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>How long was this slow performance? How long did it take to create the index
>on how much data?

To my opinion, since I got in touch with this machine (two years ago). At times, I thought something was really broken with it (wrong CPU frequency or the like).

The table itself is 3,5 GB in size with 97 Mio rows. The index was 2.8 GB. I used the "time" command:

real:	4h54m
user:	8h13m
sys:	35m

Bye
Rick Denoire Received on Fri Apr 11 2003 - 15:32:35 CDT