hey guys,
my site has been performing slower lately and i've been trying to figure out why. i was taking a look at some tables in ASPNETDB and found that there are tens of thousands of entries..... and certainly not that many actual user accounts. found them in dbo.aspnet_Profile. there's a column in there called 'propertyvaluesstring' that seems to have usernames inside it, but it also has tens of thousands of rows with "anonymous" in that column.
i think it's because i have the following code-behind on many of my pages:
if (!User.Identity.IsAuthenticated) Profile.username = "anonymous";
else Profile.username = User.Identity.Name;
i do this for purposes of doing different things depending on the user's profile name. i know this could be done better. my question is, am i right that this 30,000+ row table is effecti ...
Go to the complete details ...