Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: TFDQuery.Append slow


This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Jan 17, 2018 9:47 AM Last Post By: Matheus Guerra Threads: [ Previous | Next ]
Matheus Guerra

Posts: 2
Registered: 7/28/13
TFDQuery.Append slow  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 17, 2018 4:31 AM
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, that 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 gets slow with the SGDB in the cloud.

SGDB firebird 3.0;
Delphi 10.2 Version 25.0.28979.1978;

I believe firedac goes to the SGDB with every change in the field. Have you ever had this scenario? Can it be improved?

Edited by: Matheus Guerra on Jan 17, 2018 4:32 AM

Edited by: Matheus Guerra on Jan 17, 2018 4:35 AM
Matheus Guerra

Posts: 2
Registered: 7/28/13
Re: TFDQuery.Append slow  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 17, 2018 9:46 AM   in response to: Matheus Guerra in response to: Matheus Guerra
Problem solved.
The OnDataChange event exists.
Sorry.

Edited by: Matheus Guerra on Jan 17, 2018 9:47 AM
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02