Site slow in edit mode for datdiaplay pages
Permalink Browser Info Environment
We are having slowness on our site in edit mode. Datadisplay seems to be playing into this. The top command on server shows MySQL using up the cpu. display processlist shows this:
| 21334 | localhost | mytable | Query | 0 | Sending data | SELECT * FROM sixeightformsAnswerSets WHERE recordID = '1032' AND isDeleted != 1 |
| 21344 | localhost | mytable | Sleep | 0 | | NULL |
| 21345 | localhost | mytable | Sleep | 0 | | NULL
| 21351 | localhost | mytable | Query | 0 | Sending data | SELECT aID, value FROM sixeightformsAnswers WHERE asID='214' AND ffID=44 |
We have a lot of pages using the Advanced forms and Datadisplay. Someone said to try converting the sixeight tables to InnoDB from the MyISAM type. It did not seem to like that. Tables are back to MyISAM. Are their any adjustments we can make to it to not have it impact performance.
HAs anyone else seen thi?
| 21334 | localhost | mytable | Query | 0 | Sending data | SELECT * FROM sixeightformsAnswerSets WHERE recordID = '1032' AND isDeleted != 1 |
| 21344 | localhost | mytable | Sleep | 0 | | NULL |
| 21345 | localhost | mytable | Sleep | 0 | | NULL
| 21351 | localhost | mytable | Query | 0 | Sending data | SELECT aID, value FROM sixeightformsAnswers WHERE asID='214' AND ffID=44 |
We have a lot of pages using the Advanced forms and Datadisplay. Someone said to try converting the sixeight tables to InnoDB from the MyISAM type. It did not seem to like that. Tables are back to MyISAM. Are their any adjustments we can make to it to not have it impact performance.
HAs anyone else seen thi?
Type: | |
---|---|
Status: | New |