Cleaning up Unregistered User Profiles
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Cleaning up Unregistered User Profiles

 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server
Author Message
TechMate
Guest
Posted: Tue Jun 21, 2005 12:53 am    Post subject: Cleaning up Unregistered User Profiles Reply with quote
the UserObject table grows really large because the site creates anonymous
account every time the site is accessed, which means there are about 100000
records in the table out of which a very small percentage of the users are
registered.

Are there any administrative scripts or SQL to clean up the Basket group
and User Object table? If not is it advisable to delete all those
unregistered user profiles based on whether there is any item on the basket
associated with the user account. Please advise.
Back to top
Zoe Hart [MVP]
Guest
Posted: Tue Jun 21, 2005 4:53 pm    Post subject: Re: Cleaning up Unregistered User Profiles Reply with quote
We typically use code that only creates an anonymous account if the shopper
has cookies enabled. Otherwise you can end up creating a new anonymous
account for each page request.

We also have written our own SQL scripts to purge basket group and user
object records based on DateLastChanged. Our code makes some update to the
user profile with each visit so DateLastChanged is a good indication of
their activity on the site. So we delete anonymous user object records for
shoppers who haven't been back to the site in n days/weeks/months. Similarly
we delete basket records if nothing's been added to them in n
days/weeks/months. The decision to maintain or purge old baskets is a
business decision more than a technical one. Some sites only keep your
basket for 24 hours, others keep them indefinitely. Deleting a basket
shouldn't break anything in your site. The shopper will just start over with
an empty basket on their return.

--
Zoe Hart
Commerce Server MVP


"TechMate" <TechMate@discussions.microsoft.com> wrote in message
news:7C6CDF13-DBCA-4C59-9094-038EC8DFC73D@microsoft.com...
Quote:
the UserObject table grows really large because the site creates anonymous
account every time the site is accessed, which means there are about
100000
records in the table out of which a very small percentage of the users are
registered.

Are there any administrative scripts or SQL to clean up the Basket group
and User Object table? If not is it advisable to delete all those
unregistered user profiles based on whether there is any item on the
basket
associated with the user account. Please advise.

Back to top
EH
Guest
Posted: Tue Jun 21, 2005 4:53 pm    Post subject: Re: Cleaning up Unregistered User Profiles Reply with quote
We have implement a simiar SQL script to clean out older anonymous
users and baskets. We scheduled the job to run on a nightly basis and
clean up data older then x weeks. This should be good practice in a
site that has any significant traffic.

Eric
Back to top
Marcelo
Guest
Posted: Fri Aug 12, 2005 12:52 pm    Post subject: Re: Cleaning up Unregistered User Profiles Reply with quote
Do you send me that script? thanks

"EH" wrote:

Quote:
We have implement a simiar SQL script to clean out older anonymous
users and baskets. We scheduled the job to run on a nightly basis and
clean up data older then x weeks. This should be good practice in a
site that has any significant traffic.

Eric

Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB