I have created a VC with a formula that crashes the Appsheet Editor. The crash causes the page to become unresponsive and Chrome suggests to either wait or exit the page. Waiting does not work…
ANY(SELECT(BillingCycleInvoices[InvoiceNumber],TRUE)) is my backup formula as a proof that it works. Let me say that again, the formula here works fine.
ANY(SELECT(BillingCycleInvoices[InvoiceNumber],IN([_THISROW].[TGID],[TherapyGivenIDs]))) is the formula that causes the editor to crash when I try to save the expression in the expression editor…
Any idea why this is happening? @lizlynch @AleksiAlkio
So I believe it is due to the amount of lookups the query is returning. My first estimates is that the query is checking 18000 record lookups in 4500 records…which would indeed be a mountain for the query engine to climb! Discount this question…I’ll have to redo my formula 
1 Like
It sounds little but weird with that amount of data. Let me test with that data volume..
2 Likes
What is the solution? How can we avoid select () ?
So just to give some further information…
I had an ENUMLIST of REFS on each record in a table that holds about 4500 records.
My objective was to construct a query where a table of records that held around 19000 records looked up the 4500 record table to see if it was one of the records in the ENUMLIST column.
This caused the editor to fall over. When looking at the performance of VCs, I could see that the SELECT query I made was taking 180 + seconds to execute. So we are talking a 3 minute sync time.
However, I redefined my ENUMLIST of REFS to instead be a TEXT field. This still contained a comma separated list of refs, but I was then able to redefine my SELECT query in the other table to use CONTAINS() as one of the functions of the query instead of IN(x,LIST).
The CONTAINS function performed 5 times faster than the IN(x,LIST) function and the VC returned in 25 seconds instead of +180.
3 Likes
This is a useful observation @scott192
Thank you for sharing.
2 Likes