| Even though inactive users and clubs do use hard drive space on the database servers, they are also accessed almost never and hence don't actually contribute to the lag problems at all. It's the same reason that uninstalling programs that you don't use on your local computer will not make it faster... they are just being stored and not used. With forums it's the same deal. At best limiting the posts would make the forum search faster, but it would not have any effect on normal forum browsing or posting at all. If you want to reduce the load by deleting users and clubs, you'd have to delete the active ones. :D The biggest avenues of attack are better database caching, and more fast servers. On a big social site like this caching is difficult because the data is all constantly changing and interconnected -- though I assure you Xinil has been looking for every little optimization he can. The only real solution in my opinion is for crave to shell out some bucks to replace the slower database servers, and perhaps add some more. They have to spend money to make money, and these growing pains have already stunted the site's growth. |
 I am a banana. |
| Yep, that's true, but deleting some real inactive users could also release some unused cool and classy usernames... 8-) What do you think ? (I aways thought that deleting unused stuff from my pc could make it faster... -_-') |
| With the constant lag, the message would take forever to reach users or may not even reach the users. |
Ginraku said: Yep, that's true, but deleting some real inactive users could also release some unused cool and classy usernames... 8-) What do you think ? (I aways thought that deleting unused stuff from my pc could make it faster... -_-') That doesn't help speed up mal though, it'll probably slow it down if all of sudden there was a big clearance on users and then a number of people are trying to change their name at once. |
| There are many problems with sending mass email, the largest of which is the danger of getting mal blacklisted. Sending mail to hundreds of thousands of (mostly unverified) email addresses is obviously a naive idea for a lot of reasons, but I'd rather not go into that. The point of sending the mail in OP's idea would be to remove users, and that would not accomplish anything anyway. While there may be some benefit in removing users for whole-table queries (like forum/user search), the impact is minimal and essentially only clears disk space without significantly reducing the lag problems. The resources needed to perform the purge itself are nontrivial. The main problem is writes to the database, more than reads. For example, when you pointlessly bumped this thread (which presumably you didn't agree with) the database was forced to lock a table of posts for a few milliseconds, holding up every write waiting behind it. I don't want to sound harsh, but it's safe to say this suggestion will never see the light of day, so I'll lock it now and save the servers any more load from it. |
I am a banana. |
More topics from this board
» Yearly Wrapped like MyDramaList ?ame - Sep 6 |
13 |
by ScaryOwl
»»
Yesterday, 10:47 AM |
|
» Abusing the Number of Shared Anime and Affinity to Uncover Private Listsvazae - Mar 7, 2021 |
6 |
by Serhiyko
»»
Oct 10, 7:01 AM |
|
» Separate rating lists by genre for more fair comparisons ( 1 2 )Mathi786 - Oct 7 |
94 |
by CC
»»
Oct 9, 8:42 PM |
|
» Can there be a different completed status for rewatching a show?Rally- - Oct 3 |
5 |
by Zekkenshin
»»
Oct 9, 12:07 AM |
|
» Why isn't there a decimal rating system on mal already ( 1 2 )joyandhappiness - Sep 30 |
77 |
by AnimeManiac4Life
»»
Oct 8, 2:58 PM |