Re: What affects performance?

|> Bill Miller (turboman_at_teal.csn.org):
|> : What hardware parameters have the greatest impact on performance?
 

|> Heikki Rissanen (rissahe1_at_news.ougf.fi):
|> I think that most responses are a bit too academic. If we take a little
|> more practical approach, we can ask "What do DBA's usually do to increase
|> performance?" And the answer is something like:
|>
|> 1) Double your hardware, or triple if you can afford.
|> 2) If it doesn't help, try to figure out what's wrong.

Ad 1: Which hardware should he double? I/O channels? RAM? Disks? CPU?

      Kernel configuration (shared memory etc.)? ==>
Ad 2: Try to figure out what's wrong!

The following two books may help you:

_at_Book{Shas92,

  author =       "D.~E.~Shasha",
  title =        "Database Tuning - A Principled Approach",
  publisher =    "Prentice Hall",
  year =         1992,
  address =      "Englewood Cliffs, New Jersey 07632"

_at_Book{Louk92,
  author = "M.~Loukides",
  publisher = "O'Reilly & Associates",
  address = "103 Morris Street, Suite A, Sebastopol, CA 95472",   month = "December",
  title = "System Performance Tuning - Help For UNIX System Administrators",   year = 1992,
}

Good luck,

• Hartmut Schreiber (schreiber_at_fzi.de) In theory, there is no difference between theory and practice. But, in practice, there is.