How can I optimize the integration of CosmosDB for PostgreSQL in a .NET Core API to improve the efficiency of creating roles in the Azure Cosmos database?

Jatin Patel 0

Azure.ResourceManager.CosmosDBForPostgreSql within a .NET Core API. I've successfully implemented an update method to create roles, but it's taking more than 5 minutes to complete the task, which is longer than desired. I'm seeking solutions and recommendations to reduce the time it takes to create roles in the Azure Cosmos database.

I am using the below code to create a role which is provided in the Microsoft document, Where you can see I have used 'WaitUntil.Completed' for successful role creation but it is taking a long to create in API.

CosmosDBForPostgreSqlRoleData data = new CosmosDBForPostgreSqlRoleData("password"); ArmOperation<CosmosDBForPostgreSqlRoleResource> lro = await cosmosDBForPostgreSqlRole.UpdateAsync(WaitUntil.Completed, data); CosmosDBForPostgreSqlRoleResource result = lro.Value;

Kindly, Please give me any solution to accomplish my requirement.

Thank you.

ShaktiSingh-MSFT 15,056 Reputation points

2023-11-08T12:19:37.3033333+00:00

Hi
Jatin Patel,

Welcome to Microsoft Q&A forum.

As I understand, you want to optimize the integration of CosmosDB for PostgreSQL in a .NET Core API to improve the efficiency of creating roles in the Azure Cosmos database.

I am checking on the ask with the internal team and will get back to you.

Thanks
ShaktiSingh-MSFT 15,056 Reputation points

2023-11-10T06:47:13.4166667+00:00

Hi
Jatin Patel,

Since this question also involves other factors to consider and deeper analysis, we recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks for your patience.
Jatin Patel 0 Reputation points

2023-11-10T12:07:34.5033333+00:00

@ShaktiSingh-MSFT Yes. As of now, I don't have the right to raise a support ticket. Please help me out for this.
ShaktiSingh-MSFT 15,056 Reputation points

2023-11-13T05:26:04.57+00:00

Hi
Jatin Patel,

Could you send an email to AzCommunity@Microsoft.com with your Subscription ID and thread link to this post, and I will enable a one-time free support request for your subscription.

Please reference this forum thread in the subject:

ATTN: SHAKTI - How can I optimize the integration of CosmosDB for PostgreSQL in a .NET Core API to improve the efficiency of creating roles in the Azure Cosmos database?

Regards,

@ShaktiSingh-MSFT

Share via

How can I optimize the integration of CosmosDB for PostgreSQL in a .NET Core API to improve the efficiency of creating roles in the Azure Cosmos database?

Your answer