Forum Discussion

MichaelT_QIC's avatar
MichaelT_QIC
Frequent Visitor
5 years ago

Performance tuning Oracle ODAC driver with FetchSize option on OnPremises Data Gateway

Hello everyone,   We are using the Oracle ODAC 64bit driver in conjunction with the Microsoft OnPremises Data Gateway solution for retrieving data from a  "on prem" Oracle database and populating o...
Need Help
djpirra's avatar
djpirra
Helper III
4 years ago

I have tested that configuration but I always seem to see the Trace on PowerBI Premium to show an increase on the READDATA event by 10k rows at a time and not respecting what I have defined on the FetchSize.
Is that normal? How do I know if the fetchsize is being respected?

 

Thank you


Regards,

LS

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Keep in mind the FetchSize specifies bytes not rows. My row per trip went up significantly on all my (100+) reports, but of course the row count was different for each report. I suggest you concentrate on final load times. If you installed the ODAC Mike specified with ODP.NET installed machine wide and have seen an improvement that is a great sign FetchSize is respected. I suggest going through the Oracle documentation or forums to find the key points which you are searching. Good luck, maybe someone out there has something better or more to add than me.