Performance tuning is the process of modifying a system to improve its efficiency. This is also known as optimizing.

learn more… | top users | synonyms

3
votes
3answers
2k views

Database I/O acceleration using solid state drives

What is the experience improving database performance using solid-state drives (particularly for PostgreSQL databases) such as HP's IO Accelerator? Did you see any marked improvements?
0
votes
3answers
4k views

Oracle tuning optimizer index cost adj and optimizer index caching

What is the correct way to set the optimizer index cost adj parameter for Oracle. As a developer I have observed huge performance improvements as this parameter is lowered. Common queries are ...
3
votes
3answers
908 views

What should I set the initial MySQL Values in My.cnf to for Performance?

I am just setting up my new Linux Ubuntu 8.04 LTS server now, and getting ready for launch. My application is a PHP built application using the Zend Framework, and there is a MySQL heavy site (as are ...
1
vote
2answers
385 views

Is there any way to exclude specific files / directories from SuperFetch?

Overall, I love the SuperFetch feature in Vista and believe it results in hugely noticeable gains in the launch time and overall "snappiness" of the system. However, sometimes it apparently gets ...