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?