Re: High-Speed/Volume Database

From: Bob Hairgrove <>
Date: Sat, 11 May 2002 08:36:05 GMT
Message-ID: <>

On 10 May 2002 21:57:35 -0700, (Alexander Kuznetsov) wrote:

>Hi Bob,
>how are you going to delete 7% of records every day?
>I think that could be a big problem.

He will probably have to drop some (or all) the indexes, but it can be done; perhaps a temporary table which can be truncated? It might take some time otherwise, but this could be done at night by a batch program.

The important thing here IMHO is the file system, and whether this leads to fragmentation. With Windows, it would be a big problem. I believe Unix or AS/400 could handle this OK.

This is one of the reasons why you need a DBA for something like this!

Bob Hairgrove Received on Sat May 11 2002 - 10:36:05 CEST

Original text of this message