Re: High-Speed/Volume Database

From: Bob Hairgrove <rhairgroveNoSpam_at_Pleasebigfoot.com>
Date: Sat, 11 May 2002 08:36:05 GMT
Message-ID: <3cdcd7a0.337274@news.ch.kpnqwest.net>

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

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

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
rhairgroveNoSpam_at_Pleasebigfoot.com Received on Sat May 11 2002 - 03:36:05 CDT