I’m Running erpnext v11 for 6 months, without issues , lately the server becomes inusable for any insert with child table +100 rows or more.
i’ve configured the database for optimal performance (multiple attempts and no effect)
console prun shows
" method recv_into of _socket.socket " taking 10 seconds
method settimeout of _socket.socket " taking 8sec
connection.py:687 and 648 read_bytes and read_packet taking 6sec
protocol.py multiple times avg 2 sec
one insert operation takes 50 seconde average