Membership and Profiler in ASP.NET

Whenever you are using Sql Membership and Profiler classes - Trying to generate reports make sure your query’s WHERE clause is using “indexed” column names at least.

Let’s look at some of the more used tables. The index of some of the tables is given below:

Table: aspnet_membership

Table: aspnet_users

Table: aspnet_Profile

Bottomline - try to use ApplicationID in your queries otherwise your queries, for sure, will not run over the index at all and make it slow. This comes in effect if you are expecting high volume.
comments powered by Disqus