Server and SLOW page load issue?

Printable View

06-25-2011, 10:58 AM
eyeonprize

Server and SLOW page load issue?

Hi,

Can anybody please help me with a rough estimate of how much a server can handle before it starts to become slow. Currently there are about 1500 UIP with 3000 page load/ per day. I realize that it involves the script that calls upon sql server that can cause this. Sometimes it would take me 7-8 (frustrating) minutes just to access a page. Is that normal?? Currently I'm on VPS with 512 RAM + 1024 MB Burstable RAM. Oh and I'm using vshare 2.8.1.

Thank you
06-25-2011, 03:30 PM
bplex

What you are describing sounds about right for what your VPS should be able to handle. The most basic vShare site (little to no traffic) would be fine on that type of VPS. For anything else, you will need at least 1GB minimum of dedicated RAM. For serious sites, no less than 8GB of RAM. CPU also plays a part in this as well. The biggest load is going to come from mySQL so having plenty of RAM and CPU is essential.
06-25-2011, 06:48 PM
eyeonprize

Quote:

Originally Posted by bplex

What you are describing sounds about right for what your VPS should be able to handle. The most basic vShare site (little to no traffic) would be fine on that type of VPS. For anything else, you will need at least 1GB minimum of dedicated RAM. For serious sites, no less than 8GB of RAM. CPU also plays a part in this as well. The biggest load is going to come from mySQL so having plenty of RAM and CPU is essential.

Thanks for making that clear :)
06-26-2011, 06:05 PM
eyeonprize

Quote:

Originally Posted by bplex

What you are describing sounds about right for what your VPS should be able to handle. The most basic vShare site (little to no traffic) would be fine on that type of VPS. For anything else, you will need at least 1GB minimum of dedicated RAM. For serious sites, no less than 8GB of RAM. CPU also plays a part in this as well. The biggest load is going to come from mySQL so having plenty of RAM and CPU is essential.

In addition, my hosting keeps stressing that the high mysql usage was by the tag queries. When too many tags are added vshare mysql query to look for tags becomes very complex ultimately slowing down the sites especially if there are large number of youtube embed videos. Currently my tag table has 217,000 entries.

So do you or anyone know if there will be a fix for this issue. I apologize if this topic has been discuss before as I couldn't find it through search.

(please don't ban me by bringing up this issue, just want to make vshare better for all of us)

Thanks:grin:
06-26-2011, 11:00 PM
bplex

Tag queries really are not the problem. Rather, it's related videos (tags play a part in that). Some of my clients and I have discovered that once you reach about 10,000 videos (local or embedded, doesn't really matter), vShare starts to break down due to the massive amount of time it takes to correlate the related videos. From one site that I manage (has about 20,000 videos), I calculated that for every video that is clicked on, you generate about 400,000 relational queries. On a powerful server, it takes about 20-30 seconds to do. The only solution that I have come up with so far is to remove the related videos code completely out of vShare (out of the functions). Eventually, I'm going to probably rewrite the code or use a different method of gathering related videos.
06-27-2011, 06:27 AM
eyeonprize

Quote:

Originally Posted by bplex

The only solution that I have come up with so far is to remove the related videos code completely out of vShare (out of the functions). Eventually, I'm going to probably rewrite the code or use a different method of gathering related videos.

Yeah, currently I have about 20,000 vids +. Please share with us once you come up with the rewrite code :cool:. Or I'll even pay for something like that.

Thank you
06-28-2011, 07:18 AM
eyeonprize

Quote:

Originally Posted by bplex

The only solution that I have come up with so far is to remove the related videos code completely out of vShare (out of the functions). Eventually, I'm going to probably rewrite the code or use a different method of gathering related videos.

Regarding the related video issue. This site (custom mod?) afunnysite.com related videos seems to be shown in a different type of format. Will that make any difference in loading or is it still the same functionality? I'd appreciated any input on this.

Thanks :)
06-28-2011, 08:43 AM
vshare

Hi,

If you need related videos from ajax please open a support ticket at BuyScripts Helpdesk with your ftp,vshare admin login details.

Thanks

Buyscripts Team
09-17-2011, 06:41 PM
clonevideos

Hello there
its been long time i am not writing in this forum. i am still working on the site that currently running vshare 2.8.1 and had very slow page loading, if i could use your ajax related videos below the player? that sounds cool to me. could you please help?
09-19-2011, 05:07 AM
vshare2

Quote:

Originally Posted by clonevideos

Hello there
its been long time i am not writing in this forum. i am still working on the site that currently running vshare 2.8.1 and had very slow page loading, if i could use your ajax related videos below the player? that sounds cool to me. could you please help?

If you want ajax related videos, open a support ticket at BuyScripts Helpdesk

with your vShare admin and FTP login details.

Thanks,