0
Slow append. Tfdquery when applying value in a field with SGDB in the cloud, consumes 144 thousandths of seconds by changing the Tfdquery.Autocalcfields Property to false, this time reaches 071 thousandths of seconds. Using SGDB on the local network, the time is 004 milliseconds. Example: qry. Append; qryCODITEM.Asinteger := 1; //Here it gets slow with SGDB in the cloud.
I believe that the firedac goes to the SGDB every field change. Has anyone ever had the same scenario? Can you improve?
And if instead of putting in
Appendyou make aInsertinqry, add the value to the field and thenPost?– Junior Moreira
I changed from Append to Insert and the performance was the same. The post I call after editing the fields, I put the example only until the part where it is slow. Thank you.
– Matheus Guerra