I have a report that is pulling data from two different databases: FoxPro 3 and Oracle 8. The report runs extremely slow, if at all. CR seems to be pulling all the possible rows from Oracle and all possible rows from Foxpro and then selecting records from that pool. The "Show SQL Query" window is inactive so the SQL cannot be examined. The report utilizes usere specified parameters so using a view to limit the number of records on the Oracle side is precluded
Does anyone know of any method that may be used to make the report run faster?
We are currently using the ODBC provider to access the Foxpro tables. Would switching to the OLE provider for Foxpro expedite the query?
Thanks for the help.
Does anyone know of any method that may be used to make the report run faster?
We are currently using the ODBC provider to access the Foxpro tables. Would switching to the OLE provider for Foxpro expedite the query?
Thanks for the help.