Re: Intel processor performance

those things that impact performance most on a database system are:

1. Bus speed...how fast can the data move from memory to the processor? the processor is 4x faster than the bus in your config.
2. L2 cache (for anything running on the plaform). this helps in pipelining data from memory to the processor
3. I/O channel throughput...how many controllers? how many disks/controller, memory on the controllers, disk speed, etc...

these days, a faster processor does not do much for performance given the comparably slow bus speeds. your money would better be spent on more memory or faster controllers and disks.

"Martin Kleinman" <mkleinman-nospam-_at_desyde.nl> wrote in message news:cwYy6.14$q03.834_at_psinet-eu-nl...
> I've got a question about Oracle 8.1.7 + OAS 4.0.8.1 And processor
> performance.
>
> I'm running the database and the webserver all one 1 machine. I know this
> isn't the perfect situation but it works without any problem.
>
> The specs of the machine
>
> Asus P2B
> Celeron 400a
> 512MB memory
> 1x 1.1gig hdd for boot (WIN NT)
> 1x 20 gig hdd (split into 3 partitions, resp d: ORANT, e: OAS , f:
> swapspace)
>
> The question I've got how does the processor impact the performance of the
> machine?
>
> Does it matter much that its only a Celeron 400 with 128kb L2 Cache? Will
 a
> P2 400 (with 512kb 1/2 speed L2 Cache) improve performance a lot?
>
> What If I install a Celeron2 566 or higher (maximum supported by the
> motherboard, it doesn't support the p3, at least not that I'm aware of).
>
> Is Oracle highly dependend on the speed of the L2 Cache? Or is it highly
> dependend of the speed of the memory (thus a 100Mhz bus processor,
 P2/P3)??
>
> I suspect the latest but I'm not sure 100%
>
> Is there anyone who has some experience with this?
>
> TIA
>
> Martin Kleinman,
> Webdeveloper Desyde BV, Baarn, The Netherlands
>
>
Received on Sat Apr 07 2001 - 13:54:35 CDT