Re: delete very slow with SE ?

Posted in 1995

Caelus — 27 Jun 1995 06:17:50 GMT — source: Informix-list mailing list archive (1991-1998)

Frederic Bouquet (Frederic_Bouquet@ascus.com) wrote: : An Informix SE kernel release 5 is installed on a SCO pentium 90 MHz. : It takes 8 mins to delete at least 200 rows (or more) from a table that : contains about 56000 rows !!! of course the server is not overloaded with : other task. <stuff deleted> : here's the delete command: : delete from mouvts mou_numecr="95010100001" : Do you have any explanation about a so long time (8 mins) to delete so few : rows ? perhaps its more than just a few rows? Suggest you check your data to count exactly how many deletes are occurring. Larry Jones @ Caelus, Inc.