Yes, App B would have 2k rows if it’s using that existing table for any reason.
It’s true no matter which data source you use. Glide Tables will be better, because there isn’t any additional synchronization of data between glide and google, but data is also synced to the users device.
Consider the performance of a user’s device when they have to cache 25k row of data, or perform calculations on 25k rows of data. You can limit the amount of data there’s sent to a device if you use Row Owners.
Technically yes…for now. It may not be an enforced limit right now, but never rule out the fact that it could become a hard limit in the future. Especially with the new team plan pricing. I think it would perform well if only 1k rows are sent to the users device, and a glide table would work fine with 50k rows, but the 25k row limit is something to keep an eye on. It’s both a somewhat technical limit, and a somewhat plan based limit.