Re: cross database queries?
John R Pierce <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
On 6/26/2013 12:29 PM, Andrew Snyder wrote: > Thank you all for your replies. I am indeed talking about working > with multiple back ends (oracle, mysql, or any valid DBI module) in > the same query. thats never going to happen. DBI is not a sql processor, its just an interface, the SQL is passed directly to the database server you're connected to some databases have support for 'foreign data wrappers', where you can explicitly setup a connection to another database then use tables on that foreign database, so if you connected to a DB like this and got the FDW stuff all working, you could maybe achieve what you want, but its almost never optimal as the planner for the 'primary' database has no way to optimize JOIN operations etc involving other databases. -- john r pierce 37N 122W somewhere on the middle of the left coast