Re: Using dblinks over distance

There are other solutions, too: materialized views cache data locally and speed up selects. Replication can finish the update locally and then propagate it to remote site in the background, without users waiting.

On 1/13/20 3:20 AM, Andy Sayer wrote:
> You have a few options:
> Make the distance between DBs closer (migrate the non cloud to the
> same data centre, or migrate the cloud back to your premises).
> Increase the signal velocity (better cables, fibre optics...)
> Increase the possible bandwidth (more routes, better fibre optics...)
> Utilise more of the bandwidth you have available (change your code to
> work so it is less chatty across the link - see where most of the chat
> is coming from and start from there, favour anything but nested loop
> joins from one DB to the other)

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l