I need to run a query which will map correlationid with its correlationid1 and in turn correlationid1 to correlationid2. I am able to get the list of events in this manner using the transaction command. However it is making my search query slow for large data sets. What would be the best alternative to transaction for this kind of data set? Thanks in advance.