Slow performance when use Active Data Drivers with ADO or RDO.

[khanh]

Hi,

I created a report using C.R. 8.5 using ADO and tried again with RDO. It works fine with one table, but as soon as I added a second table and linked them with 1 same ID field. The report became real slow

http://www on

refresh. It browses through the recordset of about 5000 records; and return data. With one table the data return about 5-10 second, with 2 tables data will return but takes about 30 min or more.

Please help.