Re: Deleting all rows from standard (with loggin) table on IDS 9.40

> I have the same problem here - and I have to say, I find all of these > "solutions" ridiculous. It should not be necessary to do anything other > than "delete from whatever" unless one is just dealing with millions > upon millions of rows. I don't know about "millions upon millions", but in principle you are correct. > In my case, I've got one table with less than 900 records that have at > most 300,000 child records in all. The Oracle version of my database > has no problems, but Informix chokes on it - which I find astonishing. > Any commercial database product simply should not even blink at > deleting it all at once. I delete large chunks of records all the time. If Informix is choking on reasonable sized deletes then I expect it is rather badly misconfigured - log sizes much too small, among other things. The original question in this thread was how to delete large numbers of records and maintain a nice even performance level; the solution of dribbling deletes in order to keep an even keel is required/recommended on every database I've worked on. > Yeah, I'm a new Informix user and I don't know whatever Informix tricks > one needs to know, but I seem to be finding issue after issue on things > that just should not be issues. So far I am incredibly underwhelmed and > baffled as to why this database gets used, much less paid for.