Hi. I have a VC that is performing a lookup against a table that is a form of transactional history. It is looking for the last record when a value for the same item was zero prior to the current row in the same table. The current row is when the same value is 1. It may be that there are more than one row where the value could be 0 or 1 for the same item.
I noticed that this is causing some performance issues on sync and I wondered if it would improve matters (of the opposite) if I created a slice containing only records when this value was zero and used that in my lookup instead? Or am I trading the time to create a slice for a similar time to perform the Lookup on the whole data table?
LinkedIn
Twitter
