Avatar of stankstank
stankstank
 asked on

Profile Provider in ASP.NET 2.0

I am using the Profile Provider in ASP.NET 2.0 to keep track of personal user information.  After having the application running for several months, I viewed the profile table (where all of the information is stored) and it had records recorded which have been there for four months.  

Will this thing grow forever, or will it automatically clean its self after a certain # of records?  It amazes me that 4 month old data is stored in the profile table.  By the way, this table is [dbo].aspnet_Profile table.

Thank you,

StankStank
ASP.NET

Avatar of undefined
Last Comment
Sammy

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Sammy

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
stankstank

ASKER
So how should this be managed?  Lets say this site is going for a year, or longer...  Am I suppose to delete records from this table?  Should I maintain it?  Surely microsoft made some type of management tool for this...  How do I know what records to delete?  

If I only have a few hundred users, I would hate for this table to have hundreds of thousands of records built up over a few years...
REA_ANDREW

have you used ASP.NET's Website Administration tool? MENU in Visual Studio --> Website>ASP.NET CONFIRGURATION
stankstank

ASKER
>> have you used ASP.NET's Website Administration tool? MENU in Visual Studio --> Website>ASP.NET CONFIRGURATION <<

Yes, I have worked with the admin tool.  What does this have to do with my original question?  Please give details if this is related...
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
REA_ANDREW

well ignoring the ASP.NET Configuration tool. I have read your question further.  What I would do is this, explain to your users that any account left innactive for over a month will be deleted:

Store their Last Login Time and Date

if the Date NOW is One month later than their last login time, then delete.

Andrew
REA_ANDREW

you could make this a service running on MS SQL if it is an option for you.  I don't see why it shouldn't as you obviously do not agree with the 4 month time limit.  Decrease the time limit your self and manage in your own bespoke way.  

Microsoft provide you with the tools to achieve what you need and in some, some cases will provide the whole task for you. SOunds like in this circumstance you need to use their tools.

:-)

Andrew
Sammy

easiest thing is to create a stored procedure to drop any member last logged in a month from today's date and run the procedure once a month.

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.