Translations:Developers/Optimize performance/17/en

You might see a very different output for the time needed. In my case it nearly doubled due to the addtional list items that have to be fetched but also the time required for the SELECT ... FROM "mshop_product_list" ... tripled compared to the time when only "array( 'price', 'text', 'media' )" was used. The key problem is known and Peter Zaitsev wrote an article about this already in 2007 but the problem still exists (at least in MySQL 5.1). His solution to use the "USE INDEX (...)" hint works in principle but can't be used for the Arcavias queries as they are highly dynamic depending on the conditions that are used. The only workaround is currently to keep the number of domains in searchItems low.