Help with Sync Times

[James_McFarlane]

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?

[Grant_Stead]

It’s probably your virtual columns, whatcha doing with them?

[James_McFarlane]

Hi @Grant_Stead,

Those are automatically created by App Sheet. I tried deleting them and they got recreated.

[Grant_Stead]

If you don’t need/need a ref for the REFROWs then you can try making them enum base type REF…

[Steve]

That’s a lot of rows… Are you using a spreadsheet?

[Grant_Stead]

Yeah it is, I didn’t see that there!
I would for sure roll to ENUM base type REF…

[Grant_Stead]

And some security filters where you can to reduce the data size

[James_McFarlane]

@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?

[Grant_Stead]

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…