Link to home
Start Free TrialLog in
Avatar of chonsp
chonsp

asked on

Unlogged Transactions

The transaction log in our sybase 11 production database fills up fast
although its size is fairly large, resulting is a half-minute pause at
an unpredictable time while the log is dumped.

Under normal operation, one process deletes a large set of rows from a
table and then inserts another set.  Other processs read these rows.
I suspect the inserts and deletes are logged and cause the problem.
There is no transaction involved and we do not want to recover that
particular table if the database goes down.

Truncate table (which does not log) is not allowed in our production databases.  
Any other suggestions for getting around this problem?
ASKER CERTIFIED SOLUTION
Avatar of rferly
rferly

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chonsp
chonsp

ASKER

That would work.  But I think a more generic set rowcount and loop through the deletion process is better.