Open Closed

Numerous SQL Server selects with login #303

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)
  • 0
    hikalkan created


    I'm implementing a cache mechanism for permission checking. You can follow this issue: <a class="postlink" href=""> ... 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=""> ... o/releases</a>).