We are trying to route retrieve multiple requests to a different DB in a always ON cluster for performance reasons.
We are trying to achieve the same by writing plugin to intercept retrieve multiple requests and routing it to a read only DB which is on a secondary server in an always on cluster.
Please could you suggest how can we achieve this in plugin code or if there is a better way to achieve the same.
Thanks
*This post is locked for comments
Hi Utkarsh,
technically everything is possible (you even can use REST calls to approach another CRM database. But one question arises: why do you want to do this?
Using a retrievemultiple plugin step gives you a performance penalty. Don't go this route
If you want to enhance performance you might take a look at your database cluster. Perhaps you made some "bad" decisions in the past which bite you at this moment. What is the grow factor of the database (do you grow in increments on 1MB or do you allocate larger chunks)? What type of storage is involved? What is the amount of memory in the SQL Server?
Are there other heavy SQL processes running on the server (that might affect your performance).
You also might consider, adding indexes to the tables but that would require a thorough SQL analysis.
Instead of starting to code and creating an unmaintainable and unpredictable system, I would take a look at the environment and indexes instead.
I hope this helps you forward
Bas
Is it possible to make connection directly to DB from inside of plugin and get the data and set it in the response of retrieve all plugin?
Please suggest.
Hi
Route retrieve multiple requests is not possible
[quote user="Utkarsh Upadhyay"]
We are trying to route retrieve multiple requests to a different DB in a always ON cluster for performance reasons.
We are trying to achieve the same by writing plugin to intercept retrieve multiple requests and routing it to a read only DB which is on a secondary server in an always on cluster.
[/quote]
I don't thing it is possible to route retrieve multiple requests to different DBs but interested in knowing what other people suggest. Please mention what version and hosting environment you are in.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (