Fix wordpress woocommerce site, speed wordpress site up and optimise wordpress database
£20-250 GBP
Paid on delivery
My wordpress site is having some issues.
The site is taking to long to load when i try to duplicate products or submit new ones, regularly returning error 524 or just timing out lots.
The host has no errors reported when i raised a ticket, but thinks the problem is due to a very large database (12000 products) and it taking to long when queries are made -
=== TOP 4 of 4 (total) Slow Queries for the past 24 hours ==========
1. Executed 1m 38s ago for 47.707104 sec on Database --> Unknown (NOT FOUND / DELETED)
Date: 2019-01-31 16:43:21 Query_time: 47.707104 Rows_examined: 19279843: Rows_sent 1 Lock_time: 0.000116
# Schema: ramgfx05_wp2017 Last_errno: 1292 Killed: 0 SELECT COUNT( DISTINCT [login to view URL] ) FROM cst_posts as posts INNER JOIN cst_postmeta AS postmeta ON [login to view URL] = postmeta.post_id INNER JOIN cst_postmeta AS postmeta2 ON [login to view URL] = postmeta2.post_id WHERE 1=1 AND posts.post_type IN ( 'product', 'product_variation' ) AND posts.post_status = 'publish' AND postmeta2.meta_key = '_manage_stock' AND postmeta2.meta_value = 'yes' AND postmeta.meta_key = '_stock' AND CAST(postmeta.meta_value AS SIGNED) <= '2' AND postmeta.meta_key = '_stock' AND CAST(postmeta.meta_value AS SIGNED) > '0';
--------------------------------------------------------------------------------------------------------
2. Executed 22h 43m 47s ago for 46.973929 sec on Database --> Unknown (NOT FOUND / DELETED)
Date: 2019-01-30 18:01:12 Query_time: 46.973929 Rows_examined: 19791753: Rows_sent 0 Lock_time: 0.000129
# Schema: ramgfx05_wp2017 Last_errno: 0 Killed: 0 SELECT postmeta.post_id FROM cst_postmeta as postmeta LEFT JOIN cst_postmeta as postmeta_2 ON postmeta.post_id = postmeta_2.post_id LEFT JOIN cst_postmeta as postmeta_3 ON postmeta.post_id = postmeta_3.post_id WHERE postmeta.meta_key = '_sale_price_dates_to' AND postmeta_2.meta_key = '_price' AND postmeta_3.meta_key = '_regular_price' AND postmeta.meta_value > 0 AND postmeta.meta_value < '1548892825' AND postmeta_2.meta_value != postmeta_3.meta_value;
--------------------------------------------------------------------------------------------------------
3. Executed 1h 21m 40s ago for 46.352409 sec on Database --> Unknown (NOT FOUND / DELETED)
Date: 2019-01-31 15:23:19 Query_time: 46.352409 Rows_examined: 19261753: Rows_sent 1 Lock_time: 0.000087
# Schema: ramgfx05_wp2017 Last_errno: 1292 Killed: 0 SELECT COUNT( DISTINCT [login to view URL] ) FROM cst_posts as posts INNER JOIN cst_postmeta AS postmeta ON [login to view URL] = postmeta.post_id INNER JOIN cst_postmeta AS postmeta2 ON [login to view URL] = postmeta2.post_id WHERE 1=1 AND posts.post_type IN ( 'product', 'product_variation' ) AND posts.post_status = 'publish' AND postmeta2.meta_key = '_manage_stock' AND postmeta2.meta_value = 'yes' AND postmeta.meta_key = '_stock' AND CAST(postmeta.meta_value AS SIGNED) <= '2' AND postmeta.meta_key = '_stock' AND CAST(postmeta.meta_value AS SIGNED) > '0';
Project ID: #18637289
About the project
61 freelancers are bidding on average £200 for this job
Hello, ******************I am ready to start work on it from NOW.********************* I have 5+ years of experience in Wordpress. I assure you that you will always get a quality work from here. Thanks More
Let me help ypu today. I'm looking forward to hearing from you. BEST THAT I TRY ALWAYS PLEASE HAVE A LOOK https://www.freelancer.in/u/sismaster.html Regards, Poonam
Hey There, I am an Expert in Woocommece, WordPress. I read all the issues and Understood it completely. I am having good experience of developing anWoocommerce website using Php-Mysql, Wordpress, Magento. I am al More
Hey I am a WordPress developer and willing to customize your site and implement functionalities to work accordingly so feel free to contact and share more details
Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can do optimization of your WP DB. Let me know when you need to start. Thank You.
Hi, I understood the issue you are getting with your WordPress site. I will fix it as per your guidance. I will optimize the complete site and server (specially database). I have +7 years of experience in WordPre More
Hello, I'm wp and mysql expert with over 15 years of experience. I will debug everything, find weak places and optimize your db so it will run like a charm :) Ready to start immediatelly. Thanks
Hello, I will fix issue in your wp website as per your requirements. Please chat so we can discuss in details. We’ve built websites for several brands around the world with great success, and we are quite excite More
Hi AM READY TO START NOW. I read through the job details carefully and I am absolutely sure that we can do the project very well. In a nutshell, I'm a freelancer with more than 7 years of work experience. in B More
Dear Hiring Manager, I have read your project description and I have a few questions about it. Just say "Hi" so we can start a discussion about it. Thank You
Hi there, I’ve read your brief and can see that you’d like to done a project. My team has 8 years experience designing and developing mobile apps for iPhone and Android and web apps. I would approach your project by st More
Hello Sir, I have gone through your requirement: Wordpress site is having some issues. I have read the description and found that you are regularly returning error 524. I am proficient with PHP, WordPress, Joomla, Ma More
Hello Sir, I recommend you to move a website to AWS Hosting. I can fix your issues. I've got a very good team with very good experience of more than 8 years in PHP,Wordpress,WooCommerce,HTML,HTML5,MySQL,CSS,CS More
"Hello Sir, With our experiences in Mobile App development / Website, High skills, Full commitment to work and Perfect English, there's no doubt for me to meet. Your Requirements to full fill by us : -High Qual More
Hi, I have just saw and read the description regarding the Web DEVELOPER and WEB DESIGNER. I am glad to want to tell you that i have more experience 8+ year in this field. I can do the work as per your idea More