ERPNext is slow when fetching data

ERPNext
1

Hi,

My ERPNext is too slow when i tried to fetch data.
Is there any Multithreding option do i need to enable. As i seen i have 4 core CPU but ERPNext is not using all of that.

PFA Screenshots

Screenshot from 2017-07-14 11-17-22.png1360×768 267 KB

2

Try the slow query log. Queries usually can’t be multi-threaded. You can improve performance by indexing. Also check innodb_buffer_pool_size, should be 50-60% of your memory