Very slow sync speeds and frequent timeout errors

[YogeshLaddha]

Hello,

I have been facing very slow sync speeds and timeout errors like "Unable to fetch app definition. Error:Request cancelled: took too long to process: Computing a formula/n" from last couple of days.

Our apps have been working fine for a long time and all of sudden since last couple of days, we started getting errors like the one mentioned above.

On checking the performance analysis, I found out that most of the time is taken for computing virtual columns and reading tables. which is understandable as we gather large amount of data everyday, most of which is stored in sql db.
However, now it seems like the computation of virtual columns is taking much more time than before without any increase in amount of data or any changes or addition of Virtual columns.
Also, "Data type conversion" takes around 40-50 seconds, which I think is very high.

Can you please assist and help me understand why this is happening since last couple of days?

Thanks for your help.
@Phil @Steve @Aleksi