Forum optimization

Your Account

reacted to your score
@Silver
Joined
Jan 26, 2015
Messages
12,038
Reaction score
5,730
to do :

  • adjust database tables design
  • tune SQL's
  • improve application logic

Regarding the likes issue , it looks like the problem is in the application/database design that unfortunatelly can't cope with the amount of sherdog forums activity .

Frequent and high volume of DML(data manipulation language) SQL statements(insert, update,delete) can cause as already mentioned ,'locks' on the tables in the database where data related to 'like' statistics is stored.

Locking is a mechanism in the database engine that is used to keep database in line with refrential integrity and consistency.

Depending on the duration of a lock in the database , users of that database (sherbros) can experience a delay in response time(forums is slow, etc) ,while the database is going through those 'locked' data moments.

To fix a problem like that :

  • identify tables used to store likes information
  • identify more appropriate table desing(partitioning, index policy adjustment, etc..)
  • identify SQL's used in the likes informations flow in the database
  • tune those SQL's if possible
  • identify application logic that handles locking requests
  • tune that application logic if possible
 
Back
Top