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).

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).

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.

It may help, which you will only find out by trying, however, as noted above:

Quote:

Originally Posted by Doulos

Note: This will only delete the data from the sb_bans table, there may be other data for that player in other tables.

Only 1/4th of the data appears to be deleted, as there are cross references in other tables:

Quote:

Originally Posted by SnowHP

Its possible to remove very old bans that have expired easly?

RemoveType does (normally!) equal NULL for bans you (or other admins) haven't touched, so unless you have a heavily customized SourceBans(++) or DB, you can do the following quick-made queries:

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.