Magento mysql prcocessing at max causing site to time out

Avg Bid (USD)
Project Budget (USD)
$250 - $750

Project Description:
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.

Additional Project Description:
04/04/2013 at 11:37 PDT
This is an adult oriented site, only bid if serious and can work with this.

Skills required:
Magento, MySQL, PHP
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 515
in 5 days
$ 1000
in 25 days
$ 2000
in 30 days
$ 990
in 15 days
Hire codetrance
$ 385
in 3 days
$ 875
in 25 days
$ 384
in 3 days
$ 450
in 5 days
$ 772
in 25 days
$ 410
in 7 days