Re: Poor Oracle performance? getting rid of bind variables
Re: Poor Oracle performance? getting rid of bind variables
- Subject: Re: Poor Oracle performance? getting rid of bind variables
- From: Mike Schrag <email@hidden>
- Date: Wed, 22 Aug 2007 09:06:08 -0400
Speaking of, last week I found out the hard way that you really
have to keep your statistics up to date or else everything will be
slow. Our test server, where we don't collect statistics at all
(so I guess it was using COB), was returning results faster than
our production server (even if the prod server is like 4x more
powerful).
Yes, this is REEEALLY important, as you found. It's the same with
Postgresql, too, incidentally. Our DBAs would run stats nightly on
Oracle at my last job. It really depends on how frequently your data
changes such that your stats could be thrown off.
ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden