Re: delete very slow with SE ?

In article <3sfsbf$p3r@cssun.mathcs.emory.edu> Frederic_Bouquet@ascus.com "Frederic Bouquet" writes: > 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. Does it take the same amount of time if you drop the indexes? If so, apply them one at a time until the problem recurs. Then you have the culprite which will be an index with too many duplicate entries. Appending a unique value, or one where all combinations will be highly unique, will then sort the problem. -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================