I try to log all the queries when post a new question and there are approximately 80 queries. Some queries take a lot of time such as:
INSERT INTO qa_contentwords (postid, wordid, count, type, questionid) ~ 2s
INSERT INTO qa_titlewords (postid, wordid) ~ 1s
INSERT INTO qa_sharedevents (entitytype, entityid, questionid, lastpostid, updatetype, lastuserid, updated) ~ 1s
So it takes ~10s for posting a new question. Do you guys face up with this issue? And how to solve this problem?