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!!

[ Post a follow-up to this message ]

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.. the
n
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!!
>
>
>

[ Post a follow-up to this message ]