Execute read-only stored procedures on secondary replica
I have a many-to-many scenario close to the post below:
I have multiple entities, and the relationships between them are saved as documents and can't be denormalized.
Instead of doing multiple queries against the DB, I'd like to wrap it in a stored procedure to save round-trip time.
However, current stored procedures can only execute on primary replica, so it would be slow if the users are from another region.
Is that possible to define some read-only stored procedures so that it can be executed in read regions?
At this time we are marking this item as unplanned. We will continue to revisit this request for further votes and activity.
Thank you for your request.
This feature should be in place in first day...