RE: tuning/storage questions

2007-06-01 Thread Jim Newsham
> -Original Message- > From: Mike Matrigali [mailto:[EMAIL PROTECTED] > I'll answer below, but what I usually say in these cases is that you > are starting too low. I would not expect more than a 10% change for > any of these low level stuff. I would look more at the queries that > are

Re: tuning/storage questions

2007-06-01 Thread Mike Matrigali
Jim Newsham wrote: I’m reading the tuning guide and trying to eke out a little more performance for our app by tweaking storage parameters. The properties our database exhibits which seem potentially of important to storage tuning are: I'll answer below, but what I usually say in these

tuning/storage questions

2007-06-01 Thread Jim Newsham
I'm reading the tuning guide and trying to eke out a little more performance for our app by tweaking storage parameters. The properties our database exhibits which seem potentially of important to storage tuning are: - tables with small records (typically 3 fields; usually fixed si