A few of the EXCEL report are pulling data directly using Odata Feed directly from the production database which I think our SQL performance is being impacted due to the amount of query that we run.
I would like to know if anyone has create a SQL replication and odata feed. What do I need to achieve this?
Depending on how much of current data your users need, you could consider saving your odata query overnight into a .json file served by a web server and ask your users to use the link all day long for excel reports
If you’re not sure that the OData queries are slowing your system down, I’d suggest you do some profiling on the server to make sure you’re not barking up the wrong tree.
Even with very active users and large datasets, I almost never see OData slowing the system down. Assumedly because the actual SQL work is such a small part of the overall OData call.
I’d hate to see you setup a whole replication situation only to find that it doesn’t improve performance.