Developer forum

Forum » Ecommerce - Standard features » Product index query performance

Product index query performance

Thomas Larsen
Reply

I’m doing performance optimizations on product lists

Can anyone tell where the difference between 256ms and 849ms is coming from?

BR

Thomas

 


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

Hi Thomas

The 849 is the time from the last step in the execution table - so any code that run since the last step, will be included. Could be template code, extenders, notificiations, other DW code.

And as you can see, the query performance is affected by the facet calculations - either many facets, using containsextended or facets with too many options.

BR Nicolai

 

You must be logged in to post in the forum