Date: Fri, 31 Mar 2000 00:11:19 +1000
Reply-To: Chris Latham & Natalie Myers <chrisnat@OZEMAIL.COM.AU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Chris Latham & Natalie Myers <chrisnat@OZEMAIL.COM.AU>
Subject: Re: Efficiency note
Content-Type: text/plain; charset=us-ascii
I would hazard a guess that the file is possibly being read
from cache memory the second time around.....
I have found that in our environment (NT 4 server 1 GB RAM),
the first time a user queries a particular dataset it may take
a few minutes to complete, however subsequent queries against the
same dataset may take only seconds......
Of course, with many things always happening on the server, you
can't rely on something being in the cache....
There's no substitue for efficient coding!
(except maybe a dirty great big RAM drive....)