Other Tools for Monitoring and Boosting Performance
Relational database management systems that have been developed for production-oriented, multiuser, online applications often provide a variety of tools for monitoring and fine-tuning performance. Many of these features are outside the province of SQL per se; some systems expect you to accomplish these tasks using operating system facilities rather than those provided by the database system.
Logging
Most relational database management systems allow you to turn off the logging of database transactions, which speeds updates by saving the time it takes to enter the changes in the log. Of course, in case of a media failure, you can't rely on the database system to recover any of the changes that ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth 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.
