Transactional Control and Database Performance
Poor transactional control can hurt database performance and even bring the database to a halt. Repeatedly poor database performance may be due to a lack of transactional control during large inserts, updates, or deletes. Not only are large batch processes, such as these, demanding on the CPU and memory themselves, but the temporary storage for rollback information continues to grow until either a COMMIT or ROLLBACK command is issued.
When a COMMIT is issued, rollback transactional information is written to the target table and the rollback information in temporary storage is cleared. When a ROLLBACK is issued, no changes are made to the database and the rollback information in the temporary storage ...
Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
