Re: Sharing data between databases

On 05/11/11 9:04 PM, Tim Uckun wrote:
>> or carefully structure your dblink joins so they can perform efficiently,
>> >  possibly using temp tables as a sort of materialized view.
> According to the documents unless you are writing procedural code with
> cursors when you touch the dblink view it will pull the entire
> table/recordset over.
>

well, the idea is, you only query the remote server for the data you
know you'll need.  yeah, you can't arbitrarily do complex joins between
large tables, you want to filter as much as you can with the remote
query so the dblink only pulls across data you need.   procedures might
help too.