>hello, > >What the best way to join 2 tables across 2 databases ? > >actually i do on the 1st database a select First 100 ID from myTable1 where >... >and in the second 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 there any better way ?
Please specify 'very slow', I'd expect your query to be about as quick as you can get it. If I remember correctly, you've been discussing transaction and statement pooling on this list recently. In your statement above, are you using 100 parameters and statement pooling or creating the <id_we_retrieve_from_the_first_select> on the fly? I don't know which of these would be most efficient, both could be worth trying. Another option to consider (it might be slower) is to use a stored procedure with the IDs as one input parameter and then parse things within the stored procedure. Set
