Developer forum

Forum » CMS - Standard features » SQL Query partial index OR some other way

SQL Query partial index OR some other way

Nuno Aguiar Dynamicweb Employee
Nuno Aguiar



I have a challenge. We're working with a Query Publisher using the SqlBuilder to render a list of ordelrines associated with Digital products and it rebuilds on a 5min schedule. This basically builds a list of "My Downloads" that a customer purchased. So far so good.


Some customers experience an up to 5min delay until they can see their downloadable products, while others see them immediately (depending when they place the order relative to the schedule task being run). The problem is that this is not enough for our customer's industry standard so they are feeling penalized by it.


My solutions are:

  • Rebuild the index on order complete
    But I am concerned about volume and/or multiple orders being placed within a small time frame
  • Refactor to Data Lists and use SQL indexes
    But that's not as flexible and we have to implemente searching and faceting the "by hand" - no fun
    Performance wise is not expected to be a big issue because it's not a page users hang around a lot


Can anyone share a thought?


Best Regards,

Nuno Aguiar



You must be logged in to post in the forum