Re: Performance Tuning - speed

Try to tune sql statements with explain plan/tkprof. If you don't have control over sql statements, run program in debug mode and process trace file with tkprof, it'll show you time hogs. By the way, sometimes full table scan is working much faster than index search (rule of thumb: <5% of data - use index,

>20% - don't use index. It's a black magic between 5 and 20).

In article <01be6edf$ab24ca70$0159ea9e_at_mothergoose>,   "Wicksey" <Wicksey_at_hotmail.com> wrote:
> Hi people,
>
> I have a problem regarding the length of time my application is taking to
> execute.
> Up until a couple of days ago, everything was fine. I use ORA_FFI to
> access Pro*C code in a DLL. One of these functions was not performing
> correctly, but it was failing quickly :-) Now it works OK, but takes a
> *really* long time ie about 5 mins where it was previously 5 seconds. Can
> anyone suggest some general checks I might make - I've recreated table
> indexes with no joy. Any help would be much appreciated.
>
> Many thanks,
>
> Wicksey
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 20:24:20 CST