Hello everyone,
So, I have a beginning of answer.
The problem is the size of the buffer managed by Delphi when connecting to the database.
The first select only has 91 reads in base with a Fecth of 50 because the size of a recording is about 170 bytes
The second select is a little over 80000 reads with a Fetch of 50 because here the size of a record is 26 bytes.
I tried to change the size of the connection box buffer but that does not change anything.
How to change the size of the delphi read buffer, I guess it has to be defined either by the DataSet or not the Command object, but I can not find or!
Does anyone have an idea a track or look for?
Thank you in advance to all.

Read More...

Hi all,
I have an operating problem with the TFDTable in LWD mode, if we let delphi handle the requests, it makes this type of requests
SELECT A. * FROM [Datas]. [Dbo]. [Piece] ORDER ASC Code
The system does well the fecth and returns the recording page about 100 Rows with a Fetchsize 50.
If we impose the columns in the query like this:
SELECT A.Code, A.Category, A.State, A.DatePiece FROM [Datas]. [Dbo]. [Piece] ORDER ASC Code
The system does not do the fetch correctly anymore it does a reading of about 89000 rows
I traced in debug but I do not find what poses problem, if someone has an idea?
For information forcing the Delphi SQL engine to use specific columns I use "FTableParams.FSelectFields", present in the Delphi engine function "TFDTable.GenerateSQL"
The goal is to minimize the response time of the SQL server by avoiding "SELECT *"
Thanks in advance to all for your help

Read More...

Solution,
Create a new project
Copy the FireDAC.Comp.Client.pas file to the Project directory
Create two subdirectories (Debug and Release)
Modify the compilation options to distribute the DCUs in the directories (Debug and Realse)
In our case, we are just going to modify the 32 Bit DCUs, Search in the Delphi directory the 32Bits version of the FireDAC.Comp.Client file. *
Back up the FireDAC.Comp.Client files to replace (In case of problems being able to backtrack)
In the directory of your project copy the file FireDAC.Comp.Client.pas, then add it to your project.
Make your modifications, then build it, copy the DCUs of your files (Debug and Release) to the directories (Debug and Release of Delphi)
Open your main project and here you would have a customized version of your FireDAC.Comp.Client file

Read More...

Hello everyone,
I want to know how to compile a modification that I made in the source code of Delphi Tokyo 10.2.
I add a function in the unit: FireDAC.Comp.Client.pas, but so that I can use my modification and use the Debug I need to recompile the source.
Can someone explain to me how to do it?
Thank you in advance for your answers.

Read More...