Closed

Speedup the Wordpress first byte load which is around 5 to 8 seconds

the first byte load is slow and not consistent. See results below:

[url removed, login to view]

this is what the server host siteground told me the issue is:

I used the strace utility to trace the system calls. I noticed that there are a lot of calls like those one below:

Code:

sendto(4, "add 9d3f836a3a06384c16125ae0ewp6o_:terms:get_terms:1c593261a18a9218362975a816922718:0.556886001498653037 4 86400 6\r\na:0:{}\r\n", 124, MSG_NOSIGNAL, NULL, 0) = 124 <0.000042>

recvfrom(4, 0x199c478, 8196, 16384, 0, 0) = -1 EAGAIN (Resource temporarily unavailable) <0.000012>

poll([{fd=4, events=POLLIN}], 1, 5000) = 1 ([{fd=4, revents=POLLIN}]) <0.000013>

recvfrom(4, "NOT_STORED\r\n", 8196, MSG_NOSIGNAL, NULL, NULL) = 12 <0.000012>

sendto(4, "add 9d3f836a3a06384c16125ae0ewp6o_:pa_gek_brand_relationships:1146 4 0 6\r\na:0:{}\r\n", 82, MSG_NOSIGNAL, NULL, 0) = 82 <0.000040>

recvfrom(4, 0x199c478, 8196, 16384, 0, 0) = -1 EAGAIN (Resource temporarily unavailable) <0.000011>

It seems that each request is causing a lot of calls and queries to be send to the database. They are a lot more than normal and this is causing the delay. The MySQL service is using a lot of CPU power for your account. In this case my advice is to consider contacting your developer for assistance as there are a lot of slow MySQL queries generated like the ones below:

Code:

4. Executed 2h 26m 53s ago for 14.727886 sec on Database --> goedenko_wp747

Date: 2017-06-28 12:24:38 Query_time: 14.727886 Rows_examined: 2538: Rows_sent 1 Lock_time: 0.000135

# Schema: goedenko_wp747 Last_errno: 0 Killed: 0 SELECT [url removed, login to view] FROM wp6o_posts AS p INNER JOIN wp6o_term_relationships AS tr ON [url removed, login to view] = tr.object_id INNER JOIN wp6o_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE p.post_date > '1970-01-01 00:00:00' AND p.post_type = 'product' AND [url removed, login to view] = 'product_cat' AND tt.term_id IN (696,4679,3756,806,796,827) AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1;

Could you fix this and make the website quick again (loading around 2 to 3 seconds each time)

Skills: eCommerce, MySQL, PHP, Shopping Carts, WordPress

See more: 8 pages wordpress information site, wordpress site slow logged, video popup page load wordpress, fast load wordpress theme, popup page load wordpress, apache tuning load wordpress site, magic zoom makes site slow, apache load wordpress, lightbox popup page load wordpress, lightbox page load wordpress, load wordpress tinymce dynamically, site slow load social engine, load wordpress taxonomy ajax, load wordpress plug needed, mysql load wordpress site, dreamweaver site slow load time, display site requiring credit card adult movie load, dating makes site dating, wordpress load posts dynamically, wordpress load text post, load wordpress blog website, search site slow sql server, wordpress load text articles, zencart site slow, zen cart shopping site slow

About the Employer:
( 1 review ) Bleiswijk, Spain

Project ID: #14560518

46 freelancers are bidding on average €68 for this job

sanjay2004

Hello , Our understanding about the project is that you are looking out for your website speed optimization . Kindly share your website URL with us. We will optimize your website according to GT Metrix standards so More

€155 EUR in 0 days
(737 Reviews)
9.8
nmans

We are highly interested to work with you on this project and can assure you quality results ready to start immediately some of our developed websites are listed below E-commerce [url removed, login to view] h More

€263 EUR in 3 days
(582 Reviews)
8.5
TakeReal

Hello, My name is Sergey. I am Freelancer from [url removed, login to view], Russia. I can help you as WordPress expert to find why your site is slow and speed up it, reduce Time to fist Byte. Relevant Skills and Experience 1. "Fix More

€190 EUR in 5 days
(1603 Reviews)
7.9
tlchung

I am a skilled developer, i can help you on this. let discuss more via private message, thanks. Relevant Skills and Experience I am a skilled developer, i can help you on this. let discuss more via private message, th More

€100 EUR in 3 days
(425 Reviews)
7.5
VnBestSolutions

Dear Sir. I had read your descriptions about project. Kindly give me a chance, i would like to discuss more about project and sure everything clear. I am a developer very strong in below skills. Relevant Skills and Ex More

€121 EUR in 2 days
(213 Reviews)
7.0
€100 EUR in 2 days
(152 Reviews)
6.4
DKinfo

Hello, I’ve read your requirements and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude. I specialize in WordPress development and Design. I have been b More

€70 EUR in 2 days
(96 Reviews)
6.5
yogeshssanwal

Greetings from Webs Cybernetics!! My name is Jhalak Sanwal, Can you please come over chat to discuss further regarding the project as I would love to hear more about the idea/concept? Thanking you! Relevant Skills a More

€42 EUR in 1 day
(175 Reviews)
6.7
mithusamsukha

Dear Client 1) I can increase your website performance as i have done this many a time . 2) I will update your website in latest version 3) I will compress media files if needed 4) I will also update all plugi More

€250 EUR in 1 day
(68 Reviews)
6.3
€29 EUR in 1 day
(113 Reviews)
6.4
pgpatel

WordPress Speed Optimization I do my level best to make your site extremely fast. My expertise includes website optimization (front end & back end optimization) for WordPress and Joomla site. Relevant Skills and Ex More

€88 EUR in 2 days
(55 Reviews)
6.0
snapycode

Hey there, I am in top 1% Wordpress developer with 98% score in freelancer Wordpress skill test. I am eagerly interested to Speed up your wordpress website. ## DELIVERABELS ## 1) Speed Optimization and we wil More

€166 EUR in 5 days
(43 Reviews)
6.1
mizanbdit

Hi, I will optimize and fix the issue, I hope first byte will be loading very quickly. Relevant Skills and Experience CSS, JS, HTML, PHP, Database, Image Optimize, Caching, CDN Proposed Milestones €100 EUR - mi More

€100 EUR in 2 days
(75 Reviews)
5.8
Dckumawat

Dear Client, As per given description we can do this work and we'll fix all your issues. We are expertise in php, core php, CMS, HTML5, CSS3, bootstrap, WordPress, Shopify, Magento, PSD to HTML, Angular JS, Node More

€39 EUR in 0 days
(51 Reviews)
5.6
danale72

I can fix MySql performance issues for you in test and production environment Relevant Skills and Experience See my project history for details\references Proposed Milestones €30 EUR - Payment after trial site URL g More

€30 EUR in 3 days
(58 Reviews)
5.5
YamenS

Hi I will optimize your website code to speed up your website. Relevant Skills and Experience - WordPress, WooCommerce, membership websites, subscriptions website. - Integrate APIs with WordPress. - Both front-end a More

€29 EUR in 1 day
(53 Reviews)
5.5
etechnodroid1515

I have gone through your requirements and it will be done with best quality work. I had done this exact type of job in the past. Relevant Skills and Experience I have experience of 5+ years on eCommerce, JavaScript, More

€34 EUR in 1 day
(64 Reviews)
6.1
allphpstuff

Respected Sir/Madam, As per your site requirement , i will be the best candidate for this work as i have 5+ years experience in wordpress development , theme development and plugin developments. Relevant Skills and E More

€19 EUR in 0 days
(21 Reviews)
5.0
Zahi9

Hello Good Day, This is Zahid from Bangladesh. I hope you and your family are well :) I am a WordPress expert. I carefully read your project description. I am very interested in doing this project. I wi More

€23 EUR in 0 days
(51 Reviews)
5.1
mohsinhassan90

Hi I am a WordPress Pro I can Speed Up Your Wordpress Website, Real Professional Way Relevant Skills and Experience Google Approved > Basic SEO Proposed Milestones €34 EUR - Complete Project Fees Please Visit Our We More

€34 EUR in 10 days
(36 Reviews)
5.1