Q2A Market - Support

We are here to provide you support for Q2A Market premium and free products. If you have any issue in installation, option settings or any bug you found. Please create a ticket. We would try to get back to you as soon as possible.

As it is possible to reduce the load on the database server for a database?

I'm looking at the main page that the request comes from a great plugin Advanced Feature Questions. As it can reduce the load to optimize the query to the database.

SELECT  qa_posts.postid, qa_posts.title, qa_posts.content, qa_posts.format, qa_posts.userid,
                qa_users.userid, qa_users.email, qa_users.handle, qa_users.avatarblobid, qa_users.avatarwidth, qa_users.avatarheight, qa_users.flags
                FROM qa_posts
                LEFT OUTER JOIN qa_users ON (
                    qa_posts.userid = qa_users.userid
                )
                WHERE qa_posts.featured=1
                ORDER BY qa_posts.created DESC
                LIMIT 5;
    264.46 ms - 5 rows - 12 columns
opened on Nov 22 in Advanced Feature Questions by yerbol89

1 Answer

 
Best answer

So is this the code you have modified for the plugin and it has reduced the server load? If that is the case I would say thanks to provide me a code and will implement in the very next release.

answered Nov 23
selected Nov 30