Re: dblinks to cloud instance
Date: Sun, 18 Jul 2021 09:58:03 -0700
Message-ID: <CAN6wuX1vQbE1zsJxX+RKMvcSBBQBuQ2NhfPLe15VNfiNxc8AGw_at_mail.gmail.com>
Hate to pile onto this, but has anyone considered the egress charges from
the cloud to onprem?
This is why I so often am moving everything to the cloud. And if this is
just the beginning, they had better look into that cost!
Hope this helps,
On Sat, Jul 17, 2021 at 7:49 PM Connor McDonald <mcdonald.connor_at_gmail.com>
wrote:
> Latency is a cloud killer :-)
Kellyn
>
> This is not to say it can/should not be done, but typically you'll want to
> give some thought to app design to accommodate it.
>
> eg if you're going query a table "n" times over the course of a certain
> time duration, perhaps drag the table (or subset) down to the local node
> once into a local table or mview, and then use it.
>
> One risk of cross-database joins is the optimizer making the decision on
> where to do the join - driving_site can mitigate this risk to some degree.
>
>
> On Thu, Jul 15, 2021 at 10:46 PM Jeff Chirco <backseatdba_at_gmail.com>
> wrote:
>
>> What is your opinion on joining to a table over a database link that
>> resides in the cloud and your local database is on prem? And what if this
>> cloud instance is MSSQL and your local is Oracle?
>> We have something in the works that I just found out is supposed to go to
>> production next week. They are joining local and remote tables together. So
>> far in testing things are looking ok but the amount of data is limited
>> right now, I am unsure how much it will grow to.
>> Wondering if anyone has any experience with this.
>>
>> Thanks,
>> Jeff
>>
>
>>
>
> --
> Connor McDonald
> ===========================
> blog: connormcdonald.wordpress.com
> twitter: _at_connor_mc_d
>
> "If you are not living on the edge, you are taking up too much room."
> - Jayne Howard
>
> *Fine print: Views expressed here are my own and not necessarily that of
> my employer*
>
--
*Kellyn Gorman*
DBAKevlar Blog <http://dbakevlar.com>
about.me/dbakevlar
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jul 18 2021 - 18:58:03 CEST