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:


Hello. I can help you. Anton.

$384 USD in 3 days
(54 Reviews)

16 freelancers are bidding on average $639 for this job


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)

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)

Hello, please check our private message Thank you

$2000 USD in 30 days
(23 Reviews)

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)

I can help you. Thank you.

$385 USD in 3 days
(43 Reviews)

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

$875 USD in 25 days
(9 Reviews)

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)

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)

Ready to start now..Many thanks..

$410 USD in 7 days
(12 Reviews)

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

$632 USD in 3 days
(8 Reviews)

Ready to start now

$440 USD in 5 days
(16 Reviews)

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)

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

$450 USD in 3 days
(5 Reviews)

Kindly check your PMB for details. Thank you!

$550 USD in 3 days
(1 Review)

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)

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)

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)