Performance Advice Wanted
Date: 1995/12/14
Message-ID: <4aoo52$1jj0_at_news-s01.ny.us.ibm.net>#1/1
I have Oracle7.1 running under OS/2. Up until now, it has also been my workstation. I now have another PC (also running OS/2) as my desktop PC. The machine with Oracle on it is now a dedicated server.
Every night, files are loaded into Oracle using SQL*Loader. They are then processed. Some summary tables are built.
At present, the process is run totally on the Server. I am trying to work out if it would be better to run the process from the desktop PC.
The advantages of running it on the server is that there is no network (SQL*Net 2.1 over TCP/IP) to slow it down. The disadvantage is that the process is using memory and some processing power.
The server is a Pentium 66Mhz, 64Mb RAM, with RAID-5 on SCSI II. The desktop is a Pentium 133Mhz, 32Mb of RAM (it is newer).
Does anyone have any advice or comments?
TIA.
+---------------------------
| Simon Thompson
| Christchurch
| New Zealand
Received on Thu Dec 14 1995 - 00:00:00 CET