Magento mysql prcocessing at max causing site to time out

In Progress

I have a main store with 25 sub domains with about 20k products in main store and looking at adding more in the coming weeks, because of the load site is timing out and pages are barely loading. My hosting company has supplied the information below.

This is a problem with the way that Magento is configured or coded on your online store. As I pointed out previously, a single webpage is doing around 20,000 mysql calls. This is orders of magnitude too many. When we try and reindex, catalog url re write is stuck in processing.

It is still the amount of processing that the site is doing on each page load. The number of mysql calls has not been reduced at all. These must get fixed properly to receive full payment of bid amount.

Good communication a must and must be available via Skype, only experience with this kind of problem is preferred as time is of the essence.

Skills: Magento, MySQL, PHP

See more: reduced to the max, Magento Hosting, magento catalog, hosting magento, adding products to magento, magento payment processing, full page load, magento site url, url max, php catalog mysql, page load time magento, magento online catalog, reindex magento, good write products company, web scrapping php mysql connect magento site, full time magento, loading php mysql, problem causing, page load time, magento full page, php mysql load time, magento orders mysql, online store mysql, magento loading time, online catalog mysql

Project ID: #4395591

Awarded to:

pyostrike

Hello. I can help you. Anton.

$384 USD in 3 days
(54 Reviews)
4.8

16 freelancers are bidding on average $639 for this job

ahtsolutions

We are interested in your projects. We have been had more than 6 years experiences in developing HTML5/CSS3, Magento, Wordpress, Facebook apps, Iphone, Ipad, Android, Tab apps, Joomla, Drupal.... Please check PMB for o More

$515 USD in 5 days
(283 Reviews)
8.5
p4provider

Here are Magento Experts , please check Our Latest Magento work In PMB For Our Experience and skills Regarding Magento projects and Let me start your work , Thanks

$1000 USD in 25 days
(85 Reviews)
7.3
dinastalb

Hello, please check our private message Thank you

$2000 USD in 30 days
(23 Reviews)
6.2
getwebsolutionsl

Hi, we have expertise in HTML5 / CSS3 (Mobile Browser Compatible & Responsive), jQuery, PHP/MySQL, .Net, OsCommerce, Wordpress, Joomla, Drupal, Magento, ZenCart, Mobile Apps etc. You can see more details with PMB, Than More

$990 USD in 15 days
(30 Reviews)
6.0
codetrance

I can help you. Thank you.

$385 USD in 3 days
(43 Reviews)
5.2
pytho

Hi, Magento is my favorite eCommerce platform, please check private message for more details.

$875 USD in 25 days
(9 Reviews)
5.0
rajdeepsoftech

Hi sir Webxeon is a part of the big organsiation company RAJDEEP SOFTECH CONSULTANACYwho is also associated with FREELANCER since long time. We are an multinational company and we are more than capable to do this job b More

$450 USD in 5 days
(4 Reviews)
4.6
on2it

on2itonline: Hi, KIWI Team here at on2itonline would love to work for you on this project, we do "full service" websites on a clear and fixed budget. We have lots of offer that others don't, like our lifetime FRE More

$772 USD in 25 days
(3 Reviews)
4.6
evidcomm

Ready to start now..Many thanks..

$410 USD in 7 days
(12 Reviews)
4.5
sobhnath

Hi we are very much interested to work with you. Pls. see more details in PMB. Thanks.

$632 USD in 3 days
(8 Reviews)
4.4
honeydreams

Ready to start now

$440 USD in 5 days
(16 Reviews)
4.0
codehard

We are Magento Experts and are in business since 2006 and have developed more then 300+ Magento Projects . Lets get this Magento project done and you will not be disappointed . Please check your PMB

$550 USD in 21 days
(9 Reviews)
3.8
SSTechweb

for more information please check PMB....... Thanks

$450 USD in 3 days
(5 Reviews)
3.4
smartofts

Kindly check your PMB for details. Thank you!

$550 USD in 3 days
(1 Review)
2.0
veltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$721 USD in 25 days
(2 Reviews)
0.7
dnyaneshsonar98

Hello, i am well known Web-developer/Wordpress/php/mysql/.net/ artist with exp over15 years Check PM for more details ready to start right now

$825 USD in 2 days
(0 Reviews)
0.0
hgdumaswalakk

Dumsa is focused on providing well quality , 24/7 support as per client requirements. We have a highly qualified and experienced team of web site Certified developer in different technology. Start business Tour with More

$725 USD in 29 days
(0 Reviews)
0.0