Re: Speed executing

There is still no way to know. You have to figure out where your bottleneck is. Are you CPU bound? Are you IO bound? Adding a CPU may increase your scalability (the ability to run more queries at the same time), but it may not increase the speed of a particular query. What if you have a really slow disk or disks; adding a CPU would do nothing to increase the speed of a particular query. Also with multiple CPUs you can parallelism queries, but that does not mean in all cases the query will be faster. You need to use explain plan and tkprof to see where the bottleneck is.

You will probably get a big gain out of upgrading your software. It is no longer supported.
Jim

"mm" <meisinger_co_at_hotmail.com> wrote in message news:b5mgef$2rr0$1_at_as201.hinet.hr...
> For Jim Kennedy
>
>
> For example:
>
> 1. Case
> Query select * from product where name like 'PER%'
>
> machine 1GHz, NT 4.0, 256 MB RAM
> rows 500000
> time exec. 6 s
>
> 2. Case
> Query select * from product where name like 'PER%'
>
> machine 2x500 MHz, NT 4.0, 1 GB RAM
> rows 500000
> time exec. ???? (appr.)
>
> Thanks Jim
>
>
Received on Mon Mar 24 2003 - 08:51:13 CST