Re: How to connect 2 databases on 2 different servers and retrieve information

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 06 Mar 2006 21:22:44 +0100
Message-ID: <dui4ua$rao$1@news5.zwoll1.ov.home.nl>

sb wrote:
> Frank,
> Thanks for the information, what happens to username and password of
> t2? How do I go about with it?Do I hardcode it?
> Also, as the databases are containing millions of records, retrival
> between databases is it advised?Wouldn't there be a performance hit?
>
> Thanks
> SB
>

You did not look up database links. I'm disappointed in you. Yes it's hardcoded once - when you define the db link. And you do that just once. And can store these encrypted, too.

And what would be the difference between 1 database retrieving data, or 1 client? You need the data!

If there is much to retrieve, make sure to make it less; there are several options:

- create s subset
- create subsets in the form of materialized views locally
- join, and store as subset locally
- use your own imagination for others
-- 

Regards,
Frank van Bortel

Top-posting is one way to shut me up... Received on Mon Mar 06 2006 - 14:22:44 CST