Re: Any way around long transactions?

> > When I issue an SQL statement such as: > > insert into table select field from table1> > my logs fill up and the system chokes because of the long transaction. Is > there anyway to get around this or do I just have to do a select and an > insert, committing work after each insert? > > Same happens with a statement like: > > Delete from table> > Any ideas? e-mail me at kimgeiger@aol.com or leave a response here. Thanks > Get the FAQ and check into the section on long transactions. It's covers the bases fiarly thoroughly. | THE INFORMIX FAQ | kcbbs.gen.nz:/informix/* | mathcs.emory.edu:/pub/informix/faq/* | http://www.garpac.com/informix.html cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ "I'm with the IRS, I'm here to help you" _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________