Site Slow Issue

Jump to bottom

Jignesh Greycube edited this page Jan 31, 2023 · 1 revision

case of slow site: 
get_doc was terribly slow

checking in recorder revealed query on tabCommunication takes 15+s
checking query in dbeaver similarly takes 15s

### Solution:
1. rebuild index on tabCommunication from in dbeaver:
ANALYZE TABLE tabCommunication;
site is normal speed now

2. use mysqlcheck from terminal on server. it does analyse on all tables
sudo mysqlcheck -a coplv14

greycube.in - ERPNext Partner & Service Provider