Remote or Local?

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Thu, 20 Sep 2007 22:54:46 GMT
Message-ID: <WSCIi.54551$YL5.17263@newssvr29.news.prodigy.net>

Oracle 10.2.0.3.0, Windows 2003 Server

Two servers: Let's call server A "Lutsen" and server B "Annapurna".

Scripts are located and executed on Lutsen to read/insert/update and create indexes on tables (a few 30+ and 80+ million rows in size) all located on Annapurna.

Since the tables being processed reside on Annapurna, shouldn't the code that gets run also be located on Annapurna so that all the network traffic would be eliminated?

Also, wouldn't having this situation cause extensive, and unnecessary network traffic, which could greatly increase the time for the scripts to finish? Received on Thu Sep 20 2007 - 17:54:46 CDT