Getting information from 2 databases (Speed)

Hi,

I have the following problem: I need to fill a flexgrid that is built up from 2 databases.

First i search in an Oracle database after records that match a criteria , and then i have to look for every record if it exists on an AS400 (DB2) database.

I do this the following: first i fill my recordset with the oracle data (resulting in some 1000 records). Then i run through this recordset and for each record i make a query that searches the same record on DB2.

while not rsOr.eof
rsAS.open "select * from mytable where myfiled = '" & rsor!myoraclefield & "'",cnAS, adopenforwardonly,adlockreadonly
rsOr.movenext
wend



This works fine, but o so slowly. I've tried to load the two recordsets at once and then to use the find method in my AS400 recordset, but this recordset contains some 100 000 records and this goes even slowlier!!!


Does anybody have a suggestion??
PS: To make it more interesting: the two databases are some 50 kilometers a part.