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

On 27 Sep 2006 10:20:04 -0700, "internetuser" <yoapplesucks@yahoo.com> wrote: >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. Just as simple as that . . . > >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. How does Informix "choke on it"? > >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. > Such as? JWC