Thank you for this feedback! We plan to have more performance-related videos, and here is the link to the video you may like: kzbin.info/www/bejne/jaSyXnuAZpt2bck
@dannewell27608 ай бұрын
At time stamp 25:02 the refactored query, lines 64 - 66. The messages have only retrieved a batch of 100 records, if the message for an order is outside of the first 100 messages, will the index(wherecontains()) find the message? It is not in the batch, is the where contains going to read all the rest of the batches to go through all of the rest of the messages to get the messages for the current fv!item (order)? I don't think you will get all the messages for a given order as you are only looking at a batch of 100 and not all messages. Is that correct?
@rama020610 ай бұрын
If we could avoid moderator interference in explaining unrelated things ,give enough time to expert to explain the pros and cons of performance particular item.
@AppianCommunity10 ай бұрын
Thank you for sharing this! We'll do our best to give our SMEs more time to cover the important topics.