Re: speed up query
Disk speed is often the brick wall 'big' databases hit. So, I try to suggests ways that significantly postpone hitting that wall.
Increasing RAM so that all the data fits in cache avoids the disk barrier. But that is costly. Also, you become CPU-bound; as the data grows, so will the CPU time. This cannot be cured with hardware. We have reviewed Indexes; no further fixes available there. It has to be cured with redesigning the schema and/or application. (Hence, that is what I concentrate on.)
Once the data gets too big for cache, you get a 10x slowdown because of disk sluggishness. Then...
Faster disks won't give you 2x improvement.
RAID with striping and battery-backed-write-cache will give perhaps 3x improvement.
SSDs might give you 3x-10x improvement over RAID. But it is costly.
Then you are at the brick wall.
Subject
Views
Written By
Posted
4327
April 18, 2010 06:42AM
1609
April 18, 2010 04:04PM
1673
April 18, 2010 05:40PM
1414
April 27, 2010 02:29PM
1543
April 27, 2010 07:59PM
1410
April 28, 2010 12:12AM
1671
April 28, 2010 06:22AM
1612
April 29, 2010 01:03AM
1470
April 29, 2010 02:17AM
1488
April 29, 2010 08:19AM
1495
April 29, 2010 09:18AM
1398
April 30, 2010 12:30AM
1654
April 30, 2010 07:47AM
1578
April 30, 2010 08:21AM
1499
April 30, 2010 10:08AM
1408
May 01, 2010 02:34AM
Re: speed up query
1429
May 01, 2010 09:54AM
1375
May 01, 2010 10:48AM
1511
May 01, 2010 02:20PM
1453
May 02, 2010 03:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.