Optimmizing wordpress database with milion of rows
- or -
Post a project like this$$$
- Posted:
- Proposals: 17
- Remote
- #2019628
- Expired
REACT jS|ANGULAR 2+|NODE JS|EXPRESS JS|AWS|WORDPRESS|MONGO DB |WEB DEVELOPMENT|MY SQL|PHP WEB DEVELOPMENT
Bangalore
Ranked in Top 10 % of Web Developers on PPH - Woocommerce, Wordpress,PSD to HTML,CSS
Ahmedabad
1295168219952021970511985986195332118756611714589156839715058831011901030506803688
Description
Experience Level: Expert
Hallo,
We are running the shop with spare parts vagport.com on the base of woocommerce. We have more than 7.000 products on stock. We have implemented WPML plugin to have products in 13 languages. We have implemented own php script to have all products translated. And this made a problem. Database has grown to enormous size. Postmeta table has more than 5 million rows. All database is more than 3 GB. To edit product, it takes almost one minute to open edit product page in browser.
After analyzing the SQL query after opening the edit product page from admin panel, e.g.:
SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid
FROM p7zf_icl_languages l
LEFT JOIN p7zf_icl_translations i
ON l.code = i.language_code JOIN p7zf_icl_translation_status st
ON i.translation_id = st.translation_id
WHERE l.active = 1
AND 1=1
OR i.trid IS NULL
takes more than 10 seconds only one query.
After going to higher dedicated server, like: CPU 40 core, 256 GB RAM etc. the problem did not gone.
I am fully aware that for such a big shop implementing woocommerce was not a brilliant idea, but we have a problem now and somehow need to handle it. I wonder of possible solutions:
1. Optimize database? Maybe get rid of some rows. We already get rid of some languages but rows still remain in tables.
2. Implement customized plugin?
3. Go to other solutions?
I kindly ask for help.
Regards,
Sebastian Radek
We are running the shop with spare parts vagport.com on the base of woocommerce. We have more than 7.000 products on stock. We have implemented WPML plugin to have products in 13 languages. We have implemented own php script to have all products translated. And this made a problem. Database has grown to enormous size. Postmeta table has more than 5 million rows. All database is more than 3 GB. To edit product, it takes almost one minute to open edit product page in browser.
After analyzing the SQL query after opening the edit product page from admin panel, e.g.:
SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid
FROM p7zf_icl_languages l
LEFT JOIN p7zf_icl_translations i
ON l.code = i.language_code JOIN p7zf_icl_translation_status st
ON i.translation_id = st.translation_id
WHERE l.active = 1
AND 1=1
OR i.trid IS NULL
takes more than 10 seconds only one query.
After going to higher dedicated server, like: CPU 40 core, 256 GB RAM etc. the problem did not gone.
I am fully aware that for such a big shop implementing woocommerce was not a brilliant idea, but we have a problem now and somehow need to handle it. I wonder of possible solutions:
1. Optimize database? Maybe get rid of some rows. We already get rid of some languages but rows still remain in tables.
2. Implement customized plugin?
3. Go to other solutions?
I kindly ask for help.
Regards,
Sebastian Radek
Sebastian R.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
27 Apr 2024
Poland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Please let me know if still available?
-
Best solution is to move out of WP now otherwise you will run into these problems all the time.
654678646901
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies