Issue with "ps_ao_attribute_order"

[Mister Denial]

Hello,

 

I have issues with one SQL querry that performs extremely bad, 14+ seconds to execute - it's always the same. Does anyone know which module causes this? And how t resolve this?

 

# Query_time: 12.557685  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
use mysqlDB_TBA;
CREATE TABLE IF NOT EXISTS `ps_ao_attribute_order` (
 `ao_attributes` MEDIUMTEXT NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8

 

Your help would be much appreciated!

 

Best regards,

 

Dan

[phrasespot]

The name of the table may be a clue. Do you have any modules installed with AO as initials etc? Also it must be an attribute related module, order of the attributes maybe?

[Mister Denial]

Thank you for your help. I have located the module, but actually the module is not at fault, there is a global issue with my PS store, for which I could not pinpoint the origin yet. Apparently my website needs more than two and a half server cores to run because of slow SQL queries.

[phrasespot]

I have had similar problems with a couple of clients on shared hosting using version 1.4. I could not bring myself to ask them to upgrade as I recommended them Prestashop against Magento in a shared environment We ended up rolling back to the last version of 1.3 release. 1.3, compared to 1.4, is lighter and faster on shared hosting.

 

I also had strange results on some versions of 1.4 where the load decreased when performance tweaks were off, go figure.

[Mister Denial]

It's not the thought of upgrading to VPS that annoys me, it's just that I have this feeling inside that there is something wrong with my website, but no one can figure out.

 

If I was covinced it's just that we need a better server, I'd change in an instant, but I can't help thinking there must be an error somewhere and I HAVE to fix it. Besides, Bluehost is such a great host, I would hate to change. But if there's no alternative, well, so be it.

 

But before, I have to rule out any other possible causes for my slow scripts.

 

Because when something runs smooth and fast, and suddenly it doesn't, I HAVE to find out WHY!