Site Slow Issue - jigneshpshah/greycube_helpmanual GitHub Wiki

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