Date: Sat, 9 Jul 2005 16:39:06 -0700
Reply-To: DavidL Cassell <davidlcassell@MSN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: DavidL Cassell <davidlcassell@MSN.COM>
Subject: Re: SAS 9.1 XP not using RAM
Content-Type: text/plain; format=flowed
>We actually would not gain anything by indexing it because this is the
>very data step where we do a 'clean-up' of the data (bunch of if then
But if you're only pulling, say, 10% of the records, and that 10% can be
pulled based on one of your already-built indices, then you could still
benefit from your indexing.
OTOH, I was asking because I was wondering if you could benefit from
indexing. If you have to pull more than 10% or 20% of the file over
the network, then you may lose any benefits of the indexing, and you
might actually be better off turning the index off or at least telling SAS
not to use it.
>The connection is gigabit on both ends, so I am not sure why it is only
>doing about 20% of the gigabit bandwith.
Well, you might check the intermediate features of your network. Are
you running through some bridges or hubs? Could they be slowing down
the netwrok traffic? I've seen networks where speeds were markedly lower
when traffic had to go outside sub-networks, because of hubs (or whatever)
which weren't as fast as the other network components.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Express yourself instantly with MSN Messenger! Download today - it's FREE!