Append slow. TFDQuery when applying value in a field with SGDB in the cloud, consumes 144 thousandths of a second by changing the property TFDQuery.AutoCalcFields to false, this time reaches 071 thousandths of seconds. Using the SGDB on the local network, the time is 004 thousandths of a second. Example: qry.Append; qryCODITEM.AsInteger: = 1; // Here it slows down with the SGDB in the cloud.
I believe that firedac goes to the SGDB with every change in the field. Have you ever had a scenario like that? Can you improve?