Help with Sync Times

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…

1 Like

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

1 Like

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

1 Like

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

1 Like

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

1 Like

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…

3 Likes