Hello,
i have an urgent problem with my magento store. Everything have work great in the last 2 years. Now i have an problem with the performance! The loading times are higher then 30-40 secconds :-( I have change nothing on magento and with the server is also everything ok.
This is the answer from the Server-Provider
You create your database is paralyzed by a variety of the following queries:
UPDATE `sales_flat_quote` SET `entity_id` = '51224', `store_id` = '2',
`created_at` = '2013-01-10 03:36:17', `updated_at` = '2013-01-10 12:54:15',
`converted_at` = '0000-00-00 00:00:00', `is_active` = '1', `is_virtual` = '0',
`is_multi_shipping` = '0', `items_count` = '1425', `items_qty` = '2301',
`orig_order_id` = '0', `store_to_base_rate` = '1', `store_to_quote_rate` = '1',
`base_to_global_rate` = '1', `base_to_quote_rate` = '1', `global_currency_code` =
'EUR', `base_currency_code` = 'EUR', `store_currency_code` = 'EUR',
`quote_currency_code` = 'EUR', `grand_total` = '746817.7', `base_grand_total` =
'746817.7', `checkout_method` = '', `customer_id` = NULL, `customer_tax_class_id`
= '3', `customer_group_id` = '0', `customer_email` = NULL, `customer_prefix` =
NULL, `customer_firstname` = NULL, `customer_middlename` = NULL,
`customer_lastname` = NULL, `customer_suffix` = NULL, `customer_dob` = NULL,
`customer_note` = NULL, `customer_note_notify` = '1', `customer_is_guest` = '0',
`customer_taxvat` = NULL, `remote_ip` = '[login to view URL]', `applied_rule_ids` = '',
`reserved_order_id` = '', `password_hash` = NULL, `coupon_code` = NULL, `subtotal`
= '627733.36', `base_subtotal` = '627733.36', `subtotal_with_discount` =
'627733.36', `base_subtotal_with_discount` = '627733.36', `gift_message_id` =
NULL, `is_changed` = '1', `trigger_recollect` = '0', `ext_shipping_info` = NULL,
`customer_gender` = NULL, `invoicepdf_add_totals` = NULL, `cod_fee` = '0',
`base_cod_fee` = '0', `cod_tax_amount` = '0', `base_cod_tax_amount` = '0',
`giftcert_code` = NULL WHERE (entity_id='51224')
But this are normal queries from Magento? I need really help with that. The Store is still slow and i get also the 503 errors.
THX