| Remote query performance in BO reports [message #629726] |
Mon, 15 December 2014 12:19  |
lavk
Messages: 12
Registered: February 2010
|
Junior Member |
|
|
Hi Experts,
We some history tables at remote database.We are accessing these history data in BO reports using view.
These history tables containing the 85 million records.And BO reports are taking too much time to fetch those records in reports.
Is there any way we can minimize the round-trip in network to fetch those records in our reports/local database?
Thanks,
Lav
|
|
|
|
|
|
|
|
| Re: Remote query performance in BO reports [message #630009 is a reply to message #629820] |
Thu, 18 December 2014 09:47  |
lavk
Messages: 12
Registered: February 2010
|
Junior Member |
|
|
Hi,
Thanks for Your reply!!
I have used 'Driving_site' hint but it is not so much useful. I have checked the query with and without this hint, it is taking almost same time to complete the query.
Thanks,
Lav
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
