Re: delete very slow with SE ?

-> Frederic_Bouquet@ascus.com (Frederic Bouquet) 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 -> oth -> "John H. Frantz" <frantz@centrum.is> replied: -> I seem to recall problems with SE when rows are often deleted and inserted - -> something about the tables or index files getting larger and larger because -> deletions are actually just marked rows. You might try making a clustered -> index which will reconstruct (clean) the table and indices. And I added: Another aspect you may want to investigate is the number/complexity of indices on the table. If the table is heavily indexed with complex indices, it can have a negative effect on performance. Also look at UPDATE STATISTICS and (ha, ha!) the possibility of faulty hardware (disks/controllers), O/S kernel parameters and overly full file systems. HTH. Regards, billy.wheeler@digitec.co.za ---- Digitec Online - South Africa Telnet: bbs.digitec.co.za