Delete a Message
I did nothing yet 
I really think it depends on the amount of people and bots.
Maybe it is the result of the change asked to Google the day before?
I'll try in priority to implement what I mentioned earlier which could be easy: sending an error 429 to bots between 7PM and 4AM CET, as it seems that these hours are the most problematic. Maybe having some kind of switch that admins could enable themselves to enable that feature when they notice that the site is slow, and which would switch off a few hours later automatically.
If it is not enough, I could limit some functions at these times, for example search in comment text which is quite heavy I think for the database.
I could check that in the next week.
For less easy fixes, main two ways to improve performance would be:
- to have a list of makes, and have each car linked to a make entry rather than having the make typed in a simple text field. It is on my to-do list since long time, in addition to performance increase the other advantage would be that there could be a page with info and links about the make (that admins could edit, like a special comment just for that page).
- comments linked to user ID rather than to a username, it would be easier for the server, the only downside is that comments from deleted users would appear as anonymous.
These would rather be for September, when I'll try to find some time.
The other things I have to finish first (as I started it) is the ability to block some movies pages so only admins can edit them. I hope to have time for it this month.
I really think it depends on the amount of people and bots.
Maybe it is the result of the change asked to Google the day before?
I'll try in priority to implement what I mentioned earlier which could be easy: sending an error 429 to bots between 7PM and 4AM CET, as it seems that these hours are the most problematic. Maybe having some kind of switch that admins could enable themselves to enable that feature when they notice that the site is slow, and which would switch off a few hours later automatically.
If it is not enough, I could limit some functions at these times, for example search in comment text which is quite heavy I think for the database.
I could check that in the next week.
For less easy fixes, main two ways to improve performance would be:
- to have a list of makes, and have each car linked to a make entry rather than having the make typed in a simple text field. It is on my to-do list since long time, in addition to performance increase the other advantage would be that there could be a page with info and links about the make (that admins could edit, like a special comment just for that page).
- comments linked to user ID rather than to a username, it would be easier for the server, the only downside is that comments from deleted users would appear as anonymous.
These would rather be for September, when I'll try to find some time.
The other things I have to finish first (as I started it) is the ability to block some movies pages so only admins can edit them. I hope to have time for it this month.