Rank: Member
Joined: 6/27/2007(UTC)
Posts: 63
|
Working on a new site for a client that's been running BV for some time, performance has been a hog on their current site and upon setting it up on a new, improved server still so. Narrowed it down to the db - in particular, the bvc_authenticationtoken table has over 2 million rows and about 300Mb. I'm pretty set on dumping this table and I'm sure performance will spike from that one thing alone, but anyone know how this got so big (so I can prevent it from happening all over again) and if it's ok to wipe this out - or anything related that I should check? Thanks! |
|
|
|
|
|
|
Rank: Member
Joined: 6/27/2007(UTC)
Posts: 63
|
Some follow up details - all of the records in that table were from the same user (store admin), back for a couple of years. Could this be caused by a setting on his computer? Wiping this table clean certainly helped performance quite a bit... |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
If the client wasn't accepting cookies or was clearing cookies frequently then new cookies (and tokens) would be issued frequently. Normally, the token is valid for 24 hours only and would be cleaned up.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.