Re: Slow deleting records

In article <Hrq%1.248$z5.119255_at_proxye1.nycap.rr.com>, Dave's News <stimpson_at_visionarysoftwareSPAM.com> writes
>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.
>
>

Apart from the TRUNCATE command, make sure that there aren't any database triggers that fire on deletion of rows from the table.

HTH

-- 
Tim Shute
Software Engineering Manager

NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH
Tel: +44 (0) 1232 814121, Fax: +44 (0) 1232 813962
email: tshute_at_nisoft.co.uk
Internet: www.nisoft.co.uk