Re: Extremely slow deletes from table

And what is the sqexplain query plan? (I just hope there is SET EXPLAIN in SE, I don't remember :-)May be you should try this way : delete from pkgs where pk_pkg_id = 3685665001.0; I remember there were some problems with data conversion and query plan selection in SE (particulary with 4GL working against SE). Best Regards, Octav On Sun, Oct 10, 1999 at 10:46:52PM -0400, Michael Milom 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 -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com