Hi Guys,
Need a little help on to improve sync times base on the following reports:
What are the Table Name:Schemas and can they be improved?
It’s probably your virtual columns, whatcha doing with them?
Hi @Grant_Stead,
Those are automatically created by App Sheet. I tried deleting them and they got recreated.
If you don’t need/need a ref for the REFROWs then you can try making them enum base type REF…
That’s a lot of rows… Are you using a spreadsheet?
Yeah it is, I didn’t see that there!
I would for sure roll to ENUM base type REF…
And some security filters where you can to reduce the data size
@Steve using a MySQL DB.
It is a patient table where we need to know if they have requested a service before or have a service request in process. So for this table filters can not be applied.
@Grant_Stead Yeah it is, I didn’t see that there!
I would for sure roll to ENUM base type REF…
Like this?
Yep, then it won’t force the REFROWs virtual columns to be made, AND there is a new feature that lets the dereference expressions to still work…
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |