Transcript week13

Performance
Performance
Performance is a critical issue especially in
a multi-user environment. Benchmarking
is one way of testing this.
Benchmarking
There are numerous software utilities for
benchmarking the performance of a given
system. This will help in determining
whether or not a system is running at
optimal performance.
User Decisions
There are also things you can do as a user to
help in maintaining optimal system
performance.
• Solid database design
• Efficient query design
• Use of available system tool
Stored Procedures
Some database systems allow for the
creation and storage of Stored Procedures.
Stored Procedures is a collection of
procedural SQL statements. This is defined
on the server and accepts a list of
parameters which are used within the
statements. A result is returned.
These are much faster due to the fact they
are pre-compiled.
Database Design
• Keep your table schema as simple as
possible without compromising your
normalization
• Index only the fields that will be most
commonly used in your queries
• Select your datatypes wisely
Hardware
• Sufficient memory (RAM)
• Sufficient hard disk space
• Hard disk should have minimal
fragmentation
• Clear log files regularly
And remember…
Always have a backup system!