| Author |
Cleaning up Unregistered User Profiles
|
|
| TechMate 2005-06-20, 5:59 pm |
| 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.
| |
| Zoe Hart [MVP] 2005-06-21, 7:59 am |
| 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...
> 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.
>
>
| |
|
| 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
| |
| Marcelo 2005-08-12, 7:51 am |
| Do you send me that script? thanks
"EH" wrote:
> 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
>
>
|
|
|
|