Re: to slow for 13.000 records

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 29 Oct 1999 12:37:38 -0700
Message-ID: <3819F782.59F1D9A5@vnl.nl>

Michael Naegler wrote:

> Hi,
>
> I have a Problem :-(.
>
> We are using Oracle 8.0.4 with VFP 5. We UpSize 13.000 records into the
> Database. Then the Database is very slow.
>
> update <Tabelle> set <MemoFeld> = ' ' where <MemoFeld> is null need with
> 13.000 Record nearly 3Min. Can anyone help?
>
> Tschau
> Michael Nägler

What platform? What are your init ora settings? Is MemoFeld indexed (that would slow down!)?
What db_file_multiblock_read_count are you using? How much is in memory?

Some details, please!
--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Fri Oct 29 1999 - 14:37:38 CDT