Good day,

please advise on the best practises for the following scenario:

Description:

1)I have an SQL-Server table with over 1,000,000 records
2)and an Oracle table (also with over 1,000,000 records) on another server
3)I have an ASP.NET application that will receive a GET parameter, perform a join sql query on the field between the two tables described above to generate a PDF file based on the results.


Limitations:

1)I have no control to perform major operations like moving one of the tables to reside with the other on the same database.
2)I only have read privileges on the database, so I cannot create a temp table to hold the records of the other table.


Notes:

I have used an ASP.NET dataset to hold the two tables and performed the join with the relation class but still the operation is too slow and impractical.

What do you suggest? & thanks in advance.