Base solution for your next web application
Open Closed

Numerous SQL Server selects with login #303


User avatar
0
keithflynn created

I have just started using the Iteration Zero and added some entities and associated permissions. When I log in, I see in SQL Profiler that it does over 240 Selects against the database! I am worried that when I add more entities, permissions, roles and users that this number will skyrocket and slow down the application. Has anyone got experience with a large number of entities, users and roles?


1 Answer(s)
  • User Avatar
    0
    hikalkan created
    Support Team

    Hi,

    I'm implementing a cache mechanism for permission checking. You can follow this issue: <a class="postlink" href="https://github.com/aspnetboilerplate/module-zero/issues/101">https://github.com/aspnetboilerplate/mo ... issues/101</a>

    It will be completed in this week. When completed, you can just upgrade nuget packages and see release notes (<a class="postlink" href="https://github.com/aspnetboilerplate/module-zero/releases">https://github.com/aspnetboilerplate/mo ... o/releases</a>).

    Thanks.