I have a report that links a "oracle command" from an oracle 10g db to a ms access(.mdb) table.
The report runs very very slowly. still running after 2.5 hours....:-)
The command when run by itself returns about 290k records and completes in about 35 mins, and the ms access table has 75k records and complets in about 5 mins.
I am using the ms table as a lookup/insert, when a field in the oracle table returns an unknown value.
The oracle command pulls in about 50 fields, and the ms table is 3 fields.
i am guessing all the data from both sources is being pulled in ?, and then the link is being done in memory or temp disk space, so hence the lonnnnnnng delay ?
any suggestions how i could speed this up ?
Yes, CR retrieves the data from the Oracle database first and stores it in a temp table. Then another temp table is created for the Access database. CR then links these temp tables up.
Any record filtering is also done by CR, hence the latency!
Well, it also depends on how fast the machine is (in this scenario)- although I'm not sure how much of an improvement it might bring in.