I have a column card number (HID) which ref to another spreadsheet with 50000 rows and 2 columns HID and CSN (unique card number). In desktop version any action on the HID field is delayed for 5-10 sec. For example, I clicked on a HID field and need to wait 10 seconds for it to load, entered a number and need to wait 10 seconds for it to show the options. If I work from a computer in the Appsheet editor in the window with the mobile version everything works fine and shows the options immediately without delay, from a smartphone in the application everything works fast. If I open in a browser on my smartphone in the mobile version everything works fast, but as soon as I switch to desktop version in the same browser everything works again with a delay of 10 seconds. I used chrome and opera browsers. Data in appsheet database, in google spreadsheeets same result. No formulas used anywhere, no virtual columns, this is a test application that is set up only to test this function. I wanted to know up to how many rows can be used type ref.
I don't know how to make it public for editors. Here's a link to the app. https://www.appsheet.com/start/262632d1-85b9-4347-9630-b7da1c20fca9
LinkedIn
Twitter
