Fix wordpress woocommerce site, speed wordpress site up and optimise wordpress database

Completed Posted 5 years ago Paid on delivery
Completed 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';

CSS HTML MySQL PHP WordPress

Project ID: #18637289

About the project

61 proposals Remote project Active 5 years ago

Awarded to:

skchybd

Hi, I can improve speed and optimize database. I can make your site highest possible fast to load. My target load time is below 1 second. Website speed depends on server and website content. I work both on server an More

£200 GBP in 10 days
(100 Reviews)
5.9

61 freelancers are bidding on average £200 for this job

fastworkontime1

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

£250 GBP in 5 days
(925 Reviews)
8.8
sismaster

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

£72 GBP in 1 day
(799 Reviews)
8.1
malviyamanish

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

£500 GBP in 3 days
(305 Reviews)
7.9
aftabyounas

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

£100 GBP in 3 days
(301 Reviews)
7.3
anmoltech

Hello client, I have 7+ years experience with SEO to earn first page rankings and traffic. We believe in result oriented quality work with optimum price and time. With our excellent service, we always try to bring More

£250 GBP in 10 days
(183 Reviews)
7.0
zyeloncomputech

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.

£240 GBP in 5 days
(157 Reviews)
6.7
hawkscodes

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

£80 GBP in 1 day
(165 Reviews)
6.9
perlomonster

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

£222 GBP in 3 days
(59 Reviews)
6.5
ybisoftechg

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

£166 GBP in 3 days
(161 Reviews)
6.6
vashishtrupinder

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

£200 GBP in 1 day
(89 Reviews)
6.4
deldnm012

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

£233 GBP in 3 days
(110 Reviews)
6.4
umashankarpandey

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

£150 GBP in 3 days
(29 Reviews)
6.2
kawalecove

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

£150 GBP in 3 days
(75 Reviews)
6.3
kalinross

Hi there, Thanks for this opportunity! I have 14+ years of experience in Web development and after reading your requirements I'm 101% confident I can help you with your task. Just to prove my coding skills, you can t More

£180 GBP in 3 days
(28 Reviews)
6.2
highflextech

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

£250 GBP in 7 days
(93 Reviews)
6.0
techradr

I will fix any woocommerce issue of your woocommerce store. I will install and create your e-commerce store with wordpress woocommerce plugin. I will also modify/update your store/site according to your requireme More

£150 GBP in 5 days
(18 Reviews)
6.0
squaridroid

"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

£222 GBP in 3 days
(32 Reviews)
6.1
rairez

Hi, I have checked your requirement and I think I can help you in your project to solve the issues. I have also checked the error lists and got some idea of the issue and am confident to solve it. I would requ More

£111 GBP in 3 days
(9 Reviews)
5.6
Inovidia

We are a team of professional website developers & designers. We develop ecommerce, business, company and custom dynamic websites. You will get complete ecommerce solutions, designing, fixing, Custom Layouts & many More

£100 GBP in 3 days
(30 Reviews)
5.9
designmaster786

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

£103 GBP in 3 days
(6 Reviews)
3.8