Re: Database link performance problem

dblinks are always slow. All the rows must cross over. What I did was to create read-only snapshot and snapshot log for fast refresh on the local box. Process your data locally.

"Bernhard Acke" <ba_at_metropolis.de> wrote in message news:3b30ae84$1_at_netnews.web.de...
> Hi,
> I am generating periodically data for a few tables on a 8.1.7 instance.
 These are
> normally 200.000 datasets using 20-something SQL-queries with a database
 link to
> a seperate 8.0.5 instance ti import data from there. The time for this job
 is
> awfull. I thought about some actions to increase data import speed:
>
>
> on 8.1.5 instance:
> - sql-query optimization
> - alter tables to nologging
> - using multiple jobs/snp processes
>
>
> on net8:
> - using tcp.nodelay=true
> - altering packet size sdu
>
>
> But my feeling is, that the main bottleneck is the database link.
>
>
> What do you think about the actions above?
> Do you have any other hints?
>
>
> Bernhard
>
>
>
> --
> __________________________________________________________
> News suchen, lesen, schreiben mit http://newsgroups.web.de
>
Received on Wed Jun 20 2001 - 15:21:02 CDT