I'd beg to differ.On modern SANs writes will be acknowledged to the host system once they're written to cache (and way before they're written to disk). On the other hand reads can be completed from cache or from disk, depending on where the data is.
So, unless you're flooding your SAN's cache, writes to SAN will be quicker than reads.
Harel Safra On 07/12/2010 22:33, Amaral, Rui wrote:
It's a good chance that it's cache coming into play - though that is a very big generalization. Reads on a storage subsystem are typically faster because it doesn't have to worry about such things as parity whereas writes do (this is where you're RAID levels come into play). Rui Amaral Database Administrator ITS - SSG TD Bank Financial Group 220 Bay St., 11th Floor Toronto, ON, CA, M5K1A2 (bb) (647) 204-9106
-- //www.freelists.org/webpage/oracle-l