Re: High-Speed/Volume Database
Date: Sat, 11 May 2002 08:36:05 GMT
On 10 May 2002 21:57:35 -0700, ALexander.Kuznetsov_at_marshmc.com (Alexander Kuznetsov) wrote:
>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!
rhairgroveNoSpam_at_Pleasebigfoot.com Received on Sat May 11 2002 - 10:36:05 CEST