Fin Long queries issue on my website and speed

Peruttu Julkaistu Feb 22, 2016 Maksettu toimituksen yhteydessä
Peruttu Maksettu toimituksen yhteydessä

I do have a directory website with 300k listings , it uses WP Job Manager plugin, as well as the tags add-on for wp manager.

when I activate the tags plugin, the website load very slow and throw 502 error. but works better when I deactivate that plugin. pretty much the plugin add tags to listings. and because there are more than a millions tags, the search cause the server to overload.

My hosting support believe I need to optimize the db, rewrite queries or add indexes to improve the performance

below are some sample long queries:

[url removed, login to view]

Tietokannan hallinto Tietokantaohjelmointi MySQL Tietojärjestelmäarkkitehtuuri Web hosting

Projektin tunnus: #9731776

Tietoa projektista

5 ehdotusta Etäprojekti Aktiivinen Feb 22, 2016

5 freelanceria on tarjonnut keskimäärin $134 tähän työhön

DHSprout

Hi I have 3+ experience in web development. I did many job like this. I have strong knowledge of Mysql, Oracle, Database Design and I have also strong knowledge in languages like Java, JSP, PHP, Bootstrap CSS, Aj Lisää

$133 USD 3 päivässä
(2 arvostelua)
2.8
Deepwebexpert

Dear Client, Greetings!! I am glad to submit a proposal for your Project. I have been engaged with Web Development and Web Designing. I have 5+ year experience with WordPress Development and Web Designing. I Lisää

$155 USD 3 päivässä
(4 arvostelua)
1.8
prateektech

We have understood your requirements and assure you that the product we deliver will the impeccable and unblemished one. We promise you the highest degree of attention on concept, quality and delivery. Please re Lisää

$206 USD 7 päivässä
(0 arvostelua)
0.0