Website is slow
Hello everyone, on my sourcebans website: http://tug4elite.com/bans/ all the website is very slow. What can I do to increase the performance of website?
|
Re: Website is slow
1. Figure out what the issue is
2. Act on the issues there are. Typically, you (people in general) are going for either FREE or very CHEAP hosting, which have the side effects of being very lousy in regards to performance. Simple web hosting means that thousands of customers are often loaded on the same physical machine, which means it is probably other customers that are affecting the performance. VPS may occasionally have the same issues, where "neighbours" are affecting the performance. If you want to be sure on that part, you need a machine for yourself, which can handle your load. WE're here talking about dedicated servers (also known as "root servers", "bare metal", etc.). Getting a good and local (or very close to your country) provider will quite often also help the issues, e.g. clients from Germany would have to travel very far to reach web hosting in USA or the Asia Pacific region. Best thing here would be to take some hosting in Germany, but again, not all hosting in Germany may be good. Your own ISP could be a "low end" and lousy one, that doesn't have a very good connectivity, and in a such case, it doesn't really matter which provider you take. And also, the same thing could be effective for your hosting (and potentially: them or their ISP). The linked site loads very fast from my end though. |
Re: Website is slow
Quote:
|
Re: Website is slow
Quote:
Quote:
This could be caused by various different things, including, but not limited to: - a slow machine running the SQL database. - bad / slow and otherwise otherwise unoptimized queries Given the fact that you have more than 12k bans, those two are likely the ones hitting you. |
Re: Website is slow
Quote:
|
Re: Website is slow
Quote:
|
Re: Website is slow
Quote:
DELETE FROM sb_bans WHERE created < the unix timestamp of the date you want to start deleting bans example: To delete all bans, using a SQL query, that were created before Saturday, February 4, 2017 1:59:09 AM use: DELETE FROM sb_bans WHERE created < 148617354 There are many online unix timestamp conversion tools. Note: This will only delete the data from the sb_bans table, there may be other data for that player in other tables. |
Re: Website is slow
Quote:
|
Re: Website is slow
If it is caused by having such a large table it should help - depending on how many of the huge number of bans you have get deleted. Many other factors go into how long it takes the query to return your data and show it on the page - such as those outlined above.
Make a backup of your database first, then delete a bunch of the bans then check to see if it makes a difference. If not you can always restore your tables. |
Re: Website is slow
It may help, which you will only find out by trying, however, as noted above:
Quote:
Quote:
1. DELETE FROM sb_banlog WHERE bid IN (SELECT bid FROM sb_bans WHERE RemoveType IS NOT NULL) 2. DELETE FROM sb_comments WHERE bid IN (SELECT bid FROM sb_bans WHERE RemoveType IS NOT NULL) 3. DELETE FROM sb_protests WHERE bid IN (SELECT bid FROM sb_bans WHERE RemoveType IS NOT NULL) 4. DELETE FROM sb_bans WHERE RemoveType IS NOT NULL Be sure to run the 4th with "DELETE FROM sb_bans" as the very last one, when all the other "references" have been run and deleted. Quote:
|
All times are GMT -4. The time now is 22:53. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.