Developer forum

Forum » Ecommerce - Standard features » Product index query performance

Product index query performance

E-mail notifications
Thomas Larsen
Reply
Posted on 17/01/2024 14:45:32

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
Posted on 18/01/2024 08:18:22
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