I have a situation with our installation of Commerce Server 2000
regarding the UserObject table.  I know that every time a user come to
the site anonymously, CS2K adds a record to the UserObject table that
has blanks in most fields, i.e. the anonymous user records. These
records tend to "fill up" the UserObject table quite quickly. The
table now has over 100,000 of these anonymous records for about 4,000
or so good user records.

We attempted to simply delete these anonymous records in a scheduled
stored procedure. The records delete ok, but there is one side effect
that we are trying to solve. that is, we are finding that we have a
few pages on our site that don't work right, if one of these anonymous
users come back to the site. We think it's because of an association
to a local cookie.

In other words if user X comes to the site just to browse and never
logs in, we still drop a cookie on their local machine.  If in the
interim we were to delete his anonymous record, when he comes back to
the site some pages are showing errors. We think it has something to
do with the fact that there was a local cookie, yet it can no longer
match up to their anonymous record.

Thanks for any help--
cjsalzano@hotmail.com

[ Post a follow-up to this message ]