Re: Database Link Question (For Guru)!

From: <japs1_at_my-deja.com>
Date: Mon, 21 Aug 2000 22:56:52 GMT
Message-ID: <8nsc3b$j6v$1@nnrp1.deja.com>

Edward,

Thanks for the reply.

Can you (or anyone else) be more specific about which processor would be doing the work.

eg. if just querying Db2 tables for example from Db1, is it the Db1 server's processor that is used, or Db2's to execute the query.

Thanks again,

Paul.

In article <8nr0d9$2rum$1_at_josh.sovintel.ru>, "Edward" <eshevtsov_at_flagship.ru> wrote:
> Hello japs1.
>
> I'm not a guru, but I'll try ;-)
>
> skip...
>
> >The question I have is, where does the loading occur when a query is
> >executed from Db1 on Db2.
>
> I think it depends on type of your queries.
> If your queries are remotely (involve only Db2's tables) the most
impact
> will be on Db2
> If you have distributed queries (on both Db1's and db2's tables) the
loading
> depends on the nature of your queries
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 21 2000 - 17:56:52 CDT