Hopefully the disks were SCSI not IDE. IDE are very CPU intensive. Also
ODBC generates a lot of reparse (high CPU usage) and from VB you would be
better off with Oracle's OLE objects and use parameters. It will
signifigantly reduce the CPU usage on the server (NT or UNIX).
Jim
Gjlinker wrote in message <19990214113332.16677.00000627_at_ngol03.aol.com>...
>
>Dear all,
>
>>Has any one compiled a list of pros and cons of installing/running
>>Oracle on each platform (NT and Unix (any flavor of unix))?
>
>I don't have a list but I thought you might be interested in my findings
with
>NT last week.
>
>Environment:
>Compac server dual processor P200
>NT4 + Oracle 7.3 + 600 MB memory + 4 GB disk
>10 users selecting 100 rows from a 150.000 row table using indexes.
>15 VB programs connected via ODBC running on the server.
>
>Result:
>Processors busy for most of the time 75-100%
>Very slow performance due to high write times of Oracle.
>
>Analysis:
>Apparently PC hardware does not write to disk when processor is busy over
80%
>creating huge write times in Oracle.
>
>Solution:
>Have a dedicated box for Oracle. This rendered a cpu max of about 30-50%
under
>the same conditions, the VB apps running on a different machine taking
about
>30-40% of a single CPU P166 machine.
>
>
>Regards Gerrit-Jan Linker,
>
>*************************************************
>*| Gerrit-Jan Linker : gjlinker_at_aol.com
>*|
>*| http://members.aol.com/gjlinker
>*|
>*| Developer of:
>*| Oraxcel, OraWeb, OraSQL, OraCodes and OraDebug
>*************************************************
>LLLL IIII TTTTTTTTTTTT
>LLLL IIII TTTTTTTTTTTT
>LLLL IIII TTTT
>LLLL IIII TTTT
>LLLL IIII TTTT
>LLLL IIII TTTT
>LLLL IIII TTTT
>LLLL IIII TTTT
>LLLL IIII TTTT
>LLLL
>LLLLLLLLLLLLLLLLLLLLLLLLLLLL
>L Linker IT Consulting Ltd L
>LLLLLLLLLLLLLLLLLLLLLLLLLLLL
>
>
Received on Mon Feb 15 1999 - 08:26:29 CST
