Re: Large Delete Problem

> Mohammad Sayeed wrote: > > Hi Everyone, > I have a situation where my application is trying to do a > large delete > (actually it's a delete with no where clause) and its hitting a > "long > transaction abort". > > System: risk6000 4.1 > ------- > Informix Online 7.2 > Application using ODBC CLI > > What we already know: > --------------------- > 1. Database configauration can be changed to avoid a > long transaction > abort. > 2. Since statement in question is deleting everything in > the table we > can drop and create the table. > > The problem: > ----------- > 1. We donot have any control over the database > configuration. I > cannot make any assumtions of a certain log file size or > space either. > 2. We would prefer a controlled delete rather than a drop > or create > the table. > > Why? Dropping and recreating the table is much faster and doesn't leave > any stray junk laying around. Mohammad or Brad, Has anyone tried tuning the database engine to allow the Long Transaction to complete? When you do not have control over the data or have no idea what the data will be, nor do you have access to the database structure, then try modifying the engine configuration. Just my thoughts,