Re: What affects performance?

|> Bill Miller (turboman@teal.csn.org): |> : What hardware parameters have the greatest impact on performance? |> Heikki Rissanen (rissahe1@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: @Book{Shas92, author = "D.~E.~Shasha", title = "Database Tuning - A Principled Approach", publisher = "Prentice Hall", year = 1992, address = "Englewood Cliffs, New Jersey 07632" } @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@fzi.de) In theory, there is no difference between theory and practice. But, in practice, there is.