Row owner speed up app?

[abdo]

Row owners making it difficult for users to load the app

Just started to use row owners in order to speed up the app. We have around 8000 rows and using row owners reduces the count to 500,600 for some users. we use formulas in google sheet to fill in the row owner columns. but many users not being able to load the app data? what could be happening?

here are the 4 row owner column formulas
=ARRAYFORMULA(if(ISBLANK(A2:A), “”,“Main Admin”))
=Arrayformula(If(A2:A=“”,“Admin”))
=ARRAYFORMULA(IF(BC2:BC=“Shipped”, “Accounting”, “Operations”))
=ARRAYFORMULA(IF(BC2:BC=“Shipped”, “Accounting”, “Store”))

BC colum in the google sheet has a formula below looking up values from another sheet
=Arrayformula(If(A2:A=“”,IFERROR(VLOOKUP(A2:A,Orders!$A:$C,2,0),“Order Status Not Found”)))

the sheet formulas create an array in glide and we assign the row owner to that array column
(row-owner1, row-owner2 …row-owner4)