Re: Extremely slow deletes from table

hi Michael, many reasons can caused a suddenly shutdown of a SQL statement and "set explain on" might give u a clearer pic. have you run the update statistic on this table for the past few months ? is the table fragmented ? regards --- Michael Milom <smilom@bellsouth.net> wrote: > This is my first post, but here goes... > > We use SE 7.24UC5 for our primary database (c. 24GB, > 450 tables). Our > hardware platform is an IBM RS/6000 with 8 GB > memory. The table in > question resides on a SCSI drive (in a RAID array). > > Here is the problem. We distribute magazines. Four > tables are used to > keep track of which products go into which boxes, > and which boxes go to > which customers. Everything has been working fine > for about 10 years. > Lately, however, we have run into a very strange > problem when trying to > delete records from our pkgs (packages) table. > There is a unique index > on the pk_pkg_id field. The pk_pkg_id field is > defined as > decimal(16,0). We do not currently have referential > integrity > constraints defined, nor do we use transactions or > logging. > > Even specifying the key directly, as in > > delete from pkgs where pk_pkg_id = 3685665001;> > results in very long delete times, sometimes in the > order of 2-3 > minutes. Insertions are virtually instantaneous, > and there are no > perceptible problems with selects. bcheck (many, > many times) has turned > up absolutely nothing. The data appears to be > consistent. > > The pkgs table currently contains about 3 million > records, but that is > relatively small compared to other tables in the db > which are working > fine. We've tried everything we can think of to > correct this problems, > but nothing helps. > > Any suggestions? > > Thanks in advance > > ===== __________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com