RE: Does (block)Size really matter?
- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
- To: <rlsmith@xxxxxxx>
- Date: Wed, 08 Jun 2005 12:27:58 -0400
Ron.
Was this ever a "fast" method of inserting data? There are a lot of =
factors to consider with the work around you have created. The speed of =
the network at the time you are sending the data, the activity on the =
different boxes, the activity on the database. How much free memory do you =
have in the middle server? If you are sending data through a dblink I =
don't think the receiving database does much with it except use memory or =
temp space and then passes it on to the next link and finally to the =
table.=20
That is the method you are doing is't it. Or is it getting loaded into a =
table in the middle server and then select...insert.@last server?
Ron
--
//www.freelists.org/webpage/oracle-l
Other related posts:
