Re: Slow deleting records
From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: 1998/11/02
Message-ID: <V_q%1.15969$h45.10996082_at_news.rdc1.az.home.com>#1/1
Date: 1998/11/02
Message-ID: <V_q%1.15969$h45.10996082_at_news.rdc1.az.home.com>#1/1
>I have a table that only has 15000+ records but when I try to delete all
the
>records it takes forever. We benched marked it to about 15 minutes per
1000
>records. The only thing I can think that may cause this is that this table
>has a long datatype field but most records are very small.
>
>Any ideas would be appreciated.
>
>
If you really want to delete _ALL_ the records, use the TRUNCATE command. It's instant, and can recover the storage allocated to the table as well if you like. Received on Mon Nov 02 1998 - 00:00:00 CET