Activities of "joumingt"

Got that. This will take a while.

Hi, I apologize, but I'm having trouble understanding your meaning fully. I'm facing a dilemma here. I'm not sure whether the performance issue is caused by the database or the code.

You're getting normal speeds using both a database with basic data and your optimized code. I'm uncertain how similar your database is to the 'nas.i23.me' database I provided, which makes it difficult for me to interpret your test results.

Additionally, if your optimized code is effective, you should get similar results regardless of whether you're connecting to the 'nas.i23.me' database or your own database. Have you tested this scenario? Conversely, if the issue is code-related, using the original code I provided in my OneDrive should result in the same poor performance even with your database. Have you tested this scenario as well?

I use https://github.com/maliming/PortalApi-main project with brand new SQL server database.

Migrate and run API.Host. Login admin user, then check the permission endpoint.

Here are the results, as you can see, the response time is about 200-300ms

Hi, I'd like to confirm, when you say "with brand new SQL server database," does this refer to a database with all data included, or just an empty database with only the structure? Also, when you say you always measure speeds of 300ms, does this include using the 'nas.i23.me' DB I provided, and you obtained the same results?

Hi, Got it. I'll think about what kind of environment I can test it in.

Hi, In my current environment, there is no performance increase due to changes related to MyPermissionManagementProvider. I would like to confirm whether there are also situations where performance is low (taking 30 to 60 seconds) in your environment test? I suspect that it might be caused by my computer environment, but the differences in the environments I can test are too small (the computers of colleagues are distributed by the company).

Hi, We're sorry to have kept you waiting. I tested your modified code and found no performance improvement. Using the browser still takes more than 1 minute. Using Postman to call also takes 30 seconds. It would be helpful if you could clarify some issues for me first.

• Did your modified code improve performance in your environment?
• Based on your experience, what is the expected response speed in a scenario with thousands of Permission entries?
• Apart from database performance, what other reasons are there for the API's low performance?

Hi, I am not sure which is my username.😅 An or JB-an.

Hi, I have switched to my personal Onedrive, please confirm again.

Hi, The annoying email attachment policy keeps blocking me. I changed to upload to Onedrive sharing. Please check the email again.

mx.google.com rejected your message to the following email addresses:

liming.ma@volosoft.com (liming.ma@volosoft.com)
Your message wasn't delivered because the recipient's email provider rejected it.


mx.google.com gave this error:
This message was blocked because its content presents a potential security issue. To review our message content and attachment content guidelines, go to https://support.google.com/mail/?p=BlockedMessage 41be03b00d2f7-ae0f0da369esi18473378a12.470 - gsmtp

Hi, Sorry to have kept you waiting. Please check the email again.