Speed up my Woocommerce WP site with over 1 million products.

Currently building a Massive scalable affiliate woocommerce store that currently has 200k products. Please note I am not selling products from woocommerce. These are all affiliate products that link to third party sites. So there is no checkout or anything like that on my side.

But there is a problem.. My load times are over 50 seconds just to access the homepage. The MySQL database is currently [url removed, login to view] and I am almost positive this is the issue, a super slow database. I have a pretty serious dedicated server that only serves this site (see below). Also I have used and configured many caching plugins like W3cache and supercache. This helps with the preloading, but the problem is it’s a store and customers need to use the search bar to find there affiliate products.

I have been researching everything to get this to work, but still am unable to get the site to load under 3 seconds. This is your job. Make my site run fast, that’s it! Do I need cluster servers, cloud hosting, CDN, and on and on.

I need this setup to be scalable. What I mean by this is I am looking to load 50-100 Million (not thousands) affiliate products into the site via feeds (I have this down). But once again with this awesome dedicated server, the database is just too slow.

Dedicated server specs:

2 x Intel E5-2620 v3 Hexa-Core Haswell Xeon

CentOS 6.x

cPanel + Softaculous + Fully Managed Services

RAID 1 (2x 2TB HD drives)


100TB on 1Gbps port


Also currently using cloudflare, supercache with preload.

So freelancers how can I fix this?? I will paid $20 for the answer and configuration setup. If all goes well I have Plenty of future work for you with higher pay. Make me proud!

Beceriler: CSS, Veritabanı Programlama, PHP, WooCommerce, WordPress

Daha fazlasını gör: wp services, wp freelancers, unable to find a job, sites to find freelancers, job sites for php freelancers, job search bar work, how to work with freelancers, how to find link building freelancers, how to find a researching job, how do i fix my, freelancers bar, find my freelancers, find freelancers to work on your site, building super, add products wordpress site, adding products web site, need speed dedicated linux, commerce featured products extern site, speed dedicated server, importing products joomla site

İşveren Hakkında:
( 0 değerlendirme ) Palm Harbor, United States

Proje NO: #8395291

Bu iş için 2 freelancer ortalamada $40 teklif veriyor


Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(103 Değerlendirme)

sir,this is easy task for me.i will complete your work as soon as possible with out any [login to view URL] give me the chance to work with [login to view URL] for your reply. Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(10 Değerlendirme)