August 4, 2008 at 5:52 am
What's the difference between performance tuning and database optimization?
Many thanks.
Sahoong.
August 4, 2008 at 6:45 am
I would say that "database optimization" means turning on the right settings and indexes on the database to allow applications to run as fast as possibile, while "Performance tuning" means adjustments to queries and application logics to allow a faster execution of operations.
I don't think the two things are very different, maybe performance tuning is a process that involves database optimizations.
Regards
Gianluca
-- Gianluca Sartori
August 4, 2008 at 7:24 am
Database optimization is a subset of performance tuning.
August 4, 2008 at 7:31 am
Steven Cameron (8/4/2008)
Database optimization is a subset of performance tuning.
It took me 4 sentences to say the same thing... maybe synthesis is not one of my best qualities!:D
-- Gianluca Sartori
August 4, 2008 at 8:29 am
Database optimization would include performance tuning, and also things like backup schemes (backup size), data-scalability and normalization, storage planning (disk use), etc.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply