Re: Deleting millons of rows

Thanks, I find a criteria by a column that has a number thats is growing and it delete very fast. I already delete 20,0000,000 and I only need to delete 15,000,000 more millions. > El 26/09/2017, a las 08:45, DOUG LAWRY <douglawry@hotmail.com> escribió: > > Hi Jorge. > > The standard tool is dbdelete in this open source ESQL-C package by Art Kagel: > > ftp://ftp.iiug.org/pub/informix/pub/utils2_ak.gz > > Alternatively, it's easy enough to write a stored procedure to commit every > few thousand rows. I have a general purpose one called spl_dbdelete which uses > dynamic SQL (needs IDS 11+) so that you pass in the table name and criteria. > Perhaps I'll make my next article about that: > > https://www.oninitgroup.com/technical-articles > > Contact me directly if you want it sooner. > > Regards, > Doug > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >