Careful when querying on aspnet_users, aspnet_membership and aspnet_profile tables used by ASP.NET 2.0 Membership and Profile providerhttp://msmvps.com/blogs/omar/archive/2006/09/14/Careful-when-querying-on-aspnet_5F00_users_2C00_-aspnet_5F00_membership-and-aspnet_5F00_profile-tables-used-by-ASP.NET-2.0-Membership-and-Profile-provider.aspxSuch queries will happily run on your development environment: Select * from aspnet_users where UserName = &#39; blabla &#39; Or you can get some user&#39;s profile without any problem using: Select * from aspnet_profile where userID = &#39; &hellip;enCommunityServer 2008.5 SP2 (Build: 40407.4157)Build Google IG like Ajax Start Page in 7 days using ASP.NET Ajax and .NET 3.0http://msmvps.com/blogs/omar/archive/2006/09/14/Careful-when-querying-on-aspnet_5F00_users_2C00_-aspnet_5F00_membership-and-aspnet_5F00_profile-tables-used-by-ASP.NET-2.0-Membership-and-Profile-provider.aspx#1347591Thu, 22 Nov 2007 17:28:57 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1347591Jackie Yao<p>Introduction</p> <p>IwillshowyouhowIbuiltastartpagesimilartoGoogleIGin7nightsusingASP.Ne...</p> <img src="http://msmvps.com/aggbug.aspx?PostID=1347591" width="1" height="1">Build Google IG like Ajax Start Page in 7 days using ASP.NET Ajax and .NET 3.0（转）http://msmvps.com/blogs/omar/archive/2006/09/14/Careful-when-querying-on-aspnet_5F00_users_2C00_-aspnet_5F00_membership-and-aspnet_5F00_profile-tables-used-by-ASP.NET-2.0-Membership-and-Profile-provider.aspx#897141Thu, 10 May 2007 16:09:17 GMTd67277c4-116b-43f1-b688-e9ef184ea916:897141心悦<p>Downloadsourcecode-841.1Kb <a rel="nofollow" target="_new" href="http://www.codeproject.com/Ajax/MakingGoogleIG.asp">www.codeproject.com/.../MakingGoogleIG.asp</a></p> <img src="http://msmvps.com/aggbug.aspx?PostID=897141" width="1" height="1">英语阅读推荐：使用AJAX+WF+LINQ制作Google IG式首页http://msmvps.com/blogs/omar/archive/2006/09/14/Careful-when-querying-on-aspnet_5F00_users_2C00_-aspnet_5F00_membership-and-aspnet_5F00_profile-tables-used-by-ASP.NET-2.0-Membership-and-Profile-provider.aspx#495443Mon, 15 Jan 2007 18:28:36 GMTd67277c4-116b-43f1-b688-e9ef184ea916:495443cnblogs.com<p>如果你既想学习 ASP.NET AJAX ，又想学习 Windows Workflow Foundation ，还想学习 LINQ （包括DLinq和XLinq），能够一次过满足你三个愿望的除了 Kinder出奇蛋</p> <img src="http://msmvps.com/aggbug.aspx?PostID=495443" width="1" height="1">Build Google IG like Ajax Start Page in 7 days using ASP.NET Ajax and .NET 3.0http://msmvps.com/blogs/omar/archive/2006/09/14/Careful-when-querying-on-aspnet_5F00_users_2C00_-aspnet_5F00_membership-and-aspnet_5F00_profile-tables-used-by-ASP.NET-2.0-Membership-and-Profile-provider.aspx#472699Sat, 06 Jan 2007 02:27:35 GMTd67277c4-116b-43f1-b688-e9ef184ea916:472699ddr888<p>Introduction</p> <p>IwillshowyouhowIbuiltastartpagesimilartoGoogleIGin7nightsusingASP.Ne...</p> <img src="http://msmvps.com/aggbug.aspx?PostID=472699" width="1" height="1">re: Careful when querying on aspnet_users, aspnet_membership and aspnet_profile tables used by ASP.NET 2.0 Membership and Profile providerhttp://msmvps.com/blogs/omar/archive/2006/09/14/Careful-when-querying-on-aspnet_5F00_users_2C00_-aspnet_5F00_membership-and-aspnet_5F00_profile-tables-used-by-ASP.NET-2.0-Membership-and-Profile-provider.aspx#375805Tue, 05 Dec 2006 08:18:32 GMTd67277c4-116b-43f1-b688-e9ef184ea916:375805DIBA<p>Do use additional Indexes, if the architecture of your app makes it easy for you to utilize other columns for any of the functions stated above.</p> <p>The additional cost of additional index for &nbsp;dozen thousand of these functions will be negligible.</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=375805" width="1" height="1">re: Careful when querying on aspnet_users, aspnet_membership and aspnet_profile tables used by ASP.NET 2.0 Membership and Profile providerhttp://msmvps.com/blogs/omar/archive/2006/09/14/Careful-when-querying-on-aspnet_5F00_users_2C00_-aspnet_5F00_membership-and-aspnet_5F00_profile-tables-used-by-ASP.NET-2.0-Membership-and-Profile-provider.aspx#180864Mon, 16 Oct 2006 15:47:34 GMTd67277c4-116b-43f1-b688-e9ef184ea916:180864omar<p>New indexes slow down INSERT,UPDATE,DELETE because there are additional index to update. It's better to have least number of index but have the best possible use of them.</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=180864" width="1" height="1">re: Careful when querying on aspnet_users, aspnet_membership and aspnet_profile tables used by ASP.NET 2.0 Membership and Profile providerhttp://msmvps.com/blogs/omar/archive/2006/09/14/Careful-when-querying-on-aspnet_5F00_users_2C00_-aspnet_5F00_membership-and-aspnet_5F00_profile-tables-used-by-ASP.NET-2.0-Membership-and-Profile-provider.aspx#180506Mon, 16 Oct 2006 09:20:22 GMTd67277c4-116b-43f1-b688-e9ef184ea916:180506shortcircuitedWhat if you alter the table and add the indexes yourself?<div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=180506" width="1" height="1">