Not only that, but it's a simple plan, with forseeable end date, which can be presented to upper management. Additionally, everyone can understand it and knowingly nod their heads in agreement. Hence the importance of teaching, getting people to ask questions and think for themselves. Henry -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jared.Still@xxxxxxxxxxx Sent: Wednesday, September 01, 2004 1:24 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: ANTs Data Server? > I just don't get the whole "cache everything, and everything will be ok" > argument. The vast majority of the slow tasks I've seen in the past ten > years have all executed "in cache" to begin with! > > ...And fixing them has, almost every time, required either optimization = > of > SQL, or optimization of the application code that calls the SQL. I just > don't see how /any/ database can defend itself against all the types of > abuse that an application developer can throw at it. > Here's my take on the thought process behind this. Problem: Oracle/DB2/SQL Server is too slow. It spends too much time reading data from disk. Solution: Cache all the data. It's well known that memory access is ~14,000 times faster than disk access. We'll clean up! ;) Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To read recent messages - //freelists.org/archives/oracle-l/09-2004