Date:         Thu, 31 Aug 2000 10:10:58 -0500
Reply-To:     "Lambert, Bob" <Bob_Lambert@AFCC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Lambert, Bob" <Bob_Lambert@AFCC.COM>
Subject:      Re: Disastrous performance in V8 cf V6
Content-Type: text/plain; charset=us-ascii

I know that a memory upgrade was done on one of our UNIX boxes because V8
caused the performance to drop.  i.e.--SAS jobs took much longer to
complete, especially during peak periods.

> -----Original Message-----
> From: Stephen Dunn [SMTP:Stephen_D@HWAY.CO.UK]
> Sent: Thursday, August 31, 2000 8:09 AM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      Disastrous performance in V8 cf V6
>
>                       We run a middling size SAS database (one large table
> of 10million rows, a few others of 100,000s rows) on an NT server which we
> have just converted to using V8 software and V8 table formats from V6. The
> database updates are now taking much longer than before and its
> performance on queries is much worse. The difficulty seems to be around
> accessing files in index order rather than physical order - in some cases
> this is taking almost ten times as long as V6 used to on the same data in
> V6 formats. Even the simple act of reading a file using an index as BY
> variables after a SET statement is painfully slow.
>
>               Has anyone had similar experiences? If so, is it curable?
>
>               Stephen Dunn
>       Highway Insurance Statistician
>       Tel  (01277 266) 253
>