Drop the ODBC; very inefficient. Switch to the Oracle's OLE objects (more
efficient) and read some of the pointers they give for performance.
Also you need to determine what is slow (i.e. where is the bottleneck.) But
having a lot of CPU usage is usually an indication of a lot of reparsing due
to ODBC or badly formed queries.
Jim
Kenneth wrote in message <756aqh$hoj6_at_hkusud.hku.hk>...
>I am new to Oracle. I am suprise why perfermance is so
>bad?
>My company have an application getting a livefeed on 9600
>modem, and write the data in oracle by ODBC.
>
>The configuration of hardware and software is:
>Oracle 7.3.3.3. Workgroup Server:
>run on PII 350, AMI RAID5 Controller, IBM SCSI-II harddisks,
>256M RAM, NT Server 4.0.
>
>LiveFeed Machine:
>run PII 350, 128M RAM, IDE harddisk, VB6 ODBC program.
>
>There are around 4 or 5 tables to be updated in the server,
>and their rows size are less than 2000 and some 30 fields.
>
>The SQL of VB is a simple update based on on primary key.
>There are about 500 updates per mintues.
>
>I wonder why the cpu usage of oracle is always 80-90%. And
>it didnot drop even when there is no data from the feed.
>
>What exactly Oracle is doing???
>
>
Received on Tue Dec 15 1998 - 15:19:03 CST
