Can't edit questions on a large website

Jay Wan
asked 9 years ago

I have a website with 20000 questions when I try to go to menu page ALL Questions, I get a blank page.
The website works fine with 500 questions but not the large number of questions. I can’t figure out where is the bug.
I have 12 processor server and 64GB of RAM.
The website works just fine with 90000 posts.

2 Answers

DominicStaff
answered 9 years ago

Hi,
That’s default of wordpress and not from our plugin.
Firstly, please deactivate all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one and let us know if you find the problematic plugin(s). Maybe there is a conflict in plugins.
If you still face there issue, you can send me username & password of your site for further checking (via private answer).
Regards,

jaywan
replied 9 years ago

I deactivated all plugins and reverted to the default theme and still same issue. I think the issue is in the dwqa plugin, I have tested both CM_answers and Ana_press plugins and they both work fine with these questions.
Installed CM_answers and updated post_type from dwqa_question to CM_thread or to question in the case of anapress. they both load questions perfectly, but I like dwqa plugin more than the other 2.
I’m using php 5.4 maybe it’s a php compatibility issue.

jaywan
replied 9 years ago

when I try to access the page, the response code is 500 but I didn’t find the error in php error_log
[26/Mar/2015:20:54:49 -0400] "GET /wp-admin/edit.php?post_type=dwqa-question HTTP/1.1" 500 – "-" "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.101 Safari/537.36"

dominic Staff
replied 9 years ago

You can send me username & password of your site & FTP (via private answer) for further checking.

aamir hussain
answered 9 years ago

This is due to some complex query structure used by DWQA-Questions plguin, there are two ways to handle this issue.
Either you can improve your server specs or you can do some optimization work to reduce the server load while executing queries.

This involves query optimization as well as database optimization including the indexing this will allow dwqa-questions plugin to handle more than a million questions, depending on the no. of answers they are.

There are few plugin available for query optimization, Design Wall team should consider using these to reduce the server load caused by this plugin.
Most effective plugin is Query Monitor https://wordpress.org/plugins/query-monitor/
Just optimize the queries and make them as per the standard wordpress database indexing structure and see the magic.