| Subject | What the best way to to join 2 tables accross 2 databases ? |
|---|---|
| Author | nathanelrick |
| Post date | 2012-03-18T19:59:02Z |
hello,
What the best way to to join 2 tables accross 2 databases ?
actually i do on the 1rt database a select First 100 ID from myTable1 where ... and in the seconde database select * from MyTable2 where ID in (<id_we_retrieve_from_the_first_select>)
but the problem, the select * from MyTable2 where ID in (<id_we_retrieve_from_the_first_select>) is very slow, especially on the prepare :(
is their any better way ?
What the best way to to join 2 tables accross 2 databases ?
actually i do on the 1rt database a select First 100 ID from myTable1 where ... and in the seconde database select * from MyTable2 where ID in (<id_we_retrieve_from_the_first_select>)
but the problem, the select * from MyTable2 where ID in (<id_we_retrieve_from_the_first_select>) is very slow, especially on the prepare :(
is their any better way ?