[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
Delivered-to: email@hidden
Delivered-to: email@hidden

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:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

This email sent to email@hidden

Follow-Ups:
- Re: Poor Oracle performance? getting rid of bind variables
  - From: Guido Neitzer <email@hidden>

References:
	>Re: Poor Oracle performance? getting rid of bind variables (From: Ken Anderson <email@hidden>)
	>Re: Poor Oracle performance? getting rid of bind variables (From: Wiktor Moskwa <email@hidden>)
	>Re: Poor Oracle performance? getting rid of bind variables (From: Ken Anderson <email@hidden>)
	>Re: Poor Oracle performance? getting rid of bind variables (From: Wiktor Moskwa <email@hidden>)
	>Re: Poor Oracle performance? getting rid of bind variables (From: Guido Neitzer <email@hidden>)
	>Re: Poor Oracle performance? getting rid of bind variables (From: Wiktor Moskwa <email@hidden>)
	>Re: Poor Oracle performance? getting rid of bind variables (From: Ken Anderson <email@hidden>)
	>Re: Poor Oracle performance? getting rid of bind variables (From: Wiktor Moskwa <email@hidden>)
	>Re: Poor Oracle performance? getting rid of bind variables (From: Pascal Robert <email@hidden>)

Prev by Date: Re: Poor Oracle performance? getting rid of bind variables
Next by Date: Re: Poor Oracle performance? getting rid of bind variables
Previous by thread: Re: Poor Oracle performance? getting rid of bind variables
Next by thread: Re: Poor Oracle performance? getting rid of bind variables
Index(es):
- Date
- Thread

Home