|
Home > Archive > Commerce Server General > May 2006 > Clean null user profiles?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Clean null user profiles?
|
|
| Dean J Garrett 2006-05-24, 7:15 pm |
| We have a CS2002 classic ASP site that keeps growing the User Profile
tables. We allow guests to make purchases. Each time a guest browses the
site and catalog, an null user profile entry is made. Due to heavy user
traffic, over time the tables grow to a great degree. Does anyone have a
technique for periodically cleaning out these profiles, say once a week?
Some stored proc would be great if one exists.
Thanks!!
| |
| Ravi Shankar 2006-05-29, 5:21 pm |
| Hello Dean,
Just cleaning out the UserObject table would not help... since There are
addresses linked to these users (guests) and ofcourse there would be
anonymous basket/wishlist object also.
What I'd recommend is to write a program which basically gets all objects
from the UserObject table that match anonymous users (I forget the field..
basically it should be 0 for anonymous AND 1 for registered.. something like
that).. get the GUID's and load profiles, load addresses, load baskets...
clear baskets, delete addresses, and finally delete profiles. Needless to
say, this program would take a reasonable amount of time the first time its
run.. so you may want to setup some date-time range within which you'd
execute it.
It'd also depend on how many days worth of orders you store in your
transactions tables... so say if you store the last 3 months of orders.. then
you hsould look at eliminating only those anonymous profiles that were
created before 3 months.
--
Ravi Shankar
"Dean J Garrett" wrote:
> We have a CS2002 classic ASP site that keeps growing the User Profile
> tables. We allow guests to make purchases. Each time a guest browses the
> site and catalog, an null user profile entry is made. Due to heavy user
> traffic, over time the tables grow to a great degree. Does anyone have a
> technique for periodically cleaning out these profiles, say once a week?
> Some stored proc would be great if one exists.
>
> Thanks!!
>
>
>
|
|
|
|
|