help!

[gergokee]

Hi i'm having a strange problem. My site is so slow, if i watch it as anonymous, but if i log in as a user, everything is fast, and ok, why this can be? The videoplay stream speed is okay, just the only thing is slow is when i click on a video, and the page drives me to the video_watch page. With a user account it's fine , with anonymous it's slow...

[bplex]

This is probably due to the fact that vShare "unwisely" records each and every guest to your mySQL database. Because there is no cleanup process built into vShare, this list gets incredibly large and slows down performance for people who are not logged in. To fix this, you will have to login to your mySQL database (using a program such as phpMyAdmin) and executing the following SQL command:

truncate table `guest_info`

You can also visit the following forum topic for how you can do this via PHP and cron:

viewtopic.php?f=6&t=3955&start=0&st=0&sk=t&sd=a&hi lit=guest_info

[gergokee]

you're a god :))) Thanks very much! This was annoying :)

[mersh]

vShare records each and every guest to your mySQL database.

I never realized this. Just took a look at the guest_info table in one of my vshare installations and seeing thousands of records, dating from 2001 through 2032 (wonder what's up with THAT??!?)... haven't noticed anything slowing down, but thanks for this maintenance tip. No need to store so many useless records.

[bplex]

No problem. It kind of really depends on your server and traffic volume as to whether not you experience a slowdown. For most installations, however, you'll probably start to notice the problem around 50,000 - 100,000 records or so.

[mersh]

Any idea what the deal is with the dates ranging from 2001 to 2031? the site's only had vshare on it for a year... guess it's not all that important, just wonder where it's getting these wacky dates.

[bplex]

Well, it's using the PHP date command to create the date so the only thing that I can see that would cause it is if the date on your server was wrong at the time of a guest visiting the page. The only way that this could be important is if you are using the guest_limit features of vShare (as I believe this is the reason why guests are recorded in the first place). If you are not using the limit features, I wouldn't worry about it.