Prestashop database is causing the (Go Daddy) shared resources to be over-utilized - my site has been disabled!

[bhfashionco]

Here is the email that I received from GoDaddy....how do I go about this?

Dear Sir/Madam,

Regarding your hosting account bhfashionco.com:

It has come to our attention that your bhfashionco.com hosting account, specifically the bhfashioncodata1 database is causing the shared resources to be over-utilized. This, in turn, affects the usage by other customers.

We have disabled your database to return the server to normal usage. To re-enable your database, you will need to correct the following query:

SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, pl.`name`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, p.`id_product`, p.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, p.`id_tax`, p.`on_sale`, p.`ecotax`,
p.`quantity`, p.`price`, p.`reduction_price`, p.`reduction_percent`, p.`reduction_from`, p.`reduction_to`, p.`weight`, p.`out_of_stock`, p.`active`, p.`date_add`, p.`date_upd`,
t.`id_tax`, tl.`name` AS tax, t.`rate`, pa.`price` AS price_attribute, pa.`quantity` AS quantity_attribute,
pa.`ecotax` AS ecotax_attr, i.`id_image`, il.`legend`, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(cp.`id_product`, cp.`id_product_attribute`) AS unique_id,
IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference,
IF (IFNULL(pa.`supplier_reference`, '') = '', p.`supplier_reference`, pa.`supplier_reference`) AS supplier_reference,
(p.`weight`+ pa.`weight`) weight_attribute,
IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, pai.`id_image` AS 'pai_id_image'
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product`
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = cp.`id_product_attribute`)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = p.`id_tax`)
LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 2)

LEFT JOIN `ps_product_attribute_image` pai ON (pai.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_image` i ON (IF(pai.`id_image`,
i.`id_image` =
(SELECT i2.`id_image`
FROM `ps_image` i2
INNER JOIN `ps_product_attribute_image` pai2 ON (pai2.`id_image` = i2.`id_image`)
WHERE i2.`id_product` = p.`id_product` AND pai2.`id_product_attribute` = pa.`id_product_attribute`
ORDER BY i2.`position`
LIMIT 1),
i.`id_product` = p.`id_product` AND i.`cover` = 1)
)

LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2)
WHERE `id_cart` = 5277

AND p.`id_product` IS NOT NULL
GROUP BY unique_id
ORDER BY cp.date_add ASC

This query examines 1112777960 rows, which is unacceptable in shared hosting. Access will be reinstated upon request.

If you have questions about this matter, you may contact us by replying to this email or by calling 480-505-8871.

We appreciate your cooperation in this matter.

Hosting Support Team

[TBDC]

Switch to "this company":http://www.bluehost.com/track/businessdevelopmentcenter
I have never had a problem with them shutting my account down for useage. Go Daddy just sucks - I had them for my reseller account and there was always problems for my clients. I have been with the above company for 3 years and they are awesome

[tomerg3]

I would not go to bluehost just yet, I personally used them before, and even though I recommend them (much better than goddady), you may be too big for shared hosting.

How many categories do you have?
How many products do you have?
How many products with attributes, How many combination per product (average)?
How many monthly visitors do you get?