Too large to handle

[GarzaSO]

I often receive an error message because data is too large, sometimes because it is large and sometimes because there is server errors. It is kind of annoying because I might have understood wrong the million rows data stuff, thinking it was possible to work with lots of data joins.

So, this screenshot shows the error by pasting, but I also receive the same when I just write it. And as a bit of context, those 3 records are also working in another table as lookups, attached to 160 records so I can calculate the overall cost of materials for each, but when I try to update the fields shown here, that represents price, it seems to struggle to do it.

*UPDATE:
I created new records that I added the whole data first before using lookup, when I joined them and made a formula to gave me what I wanted, it finally worked. BUT, whenever I tried to modify the records shown in the screenshot to change price, it will prompt me back again with the too large error message. Unfortunately, I guess I hit a limit :/

[tea-artist]

Currently, if the calculation takes more than 5 seconds, we will prompt that the operation is too large. We will continue to optimize and improve performance

[GarzaSO]

Got it, thanks!

[dkindlund]

This is the same issue as reported here:
#1869 (comment)

The long-term solution is for Teable to implement like an adjustable SMALL_TRANSACTION_TIMEOUT environment variable.