mario.arosio@gmail.com

The issue is that on SqlServer it takes just one second, and using the BDE as well.

Using FD it takes 3 minutes and more, but if I take off the grouping function, it takes just one second. It seems like FD execute the query on server side, and I don't know why.

Connectiong to a local server, I was able to see on Task Manager that it's working serverside 

21 hours ago, programmerdelphi2k said:

post your SQL text ( not need all Fields ... just fields used to create the "joins" between tables ) ... how is it?

 

... from t1 as b 
left join t2 as r on r.codet=b.codice  
left join t3 as a  on r.codart=a.codice
left join t4 on t4.codice=b.t4 and b.clf=t4.tipo 
join t5 as o on b.ordine=o.codice 
join t6 as p on b.codpag=p.codice
where ...

.. group by ...

As this is a aumatical generated code, there is no an aggregate function on the Select statement, so I can take off the Group by statement and put a Distinct clause, but this not increase the perfoermance

Find out a brand new clue: I have a Select on 3 tables, and returns 21k rows.
Executing this query on BDE, on FD and SQLServer takes about 1 second.

Then, I decided to add a Group By clause to the query, and the result set is now about 2.5k records.
Unfortunately, it takes more or less the same time on BDE and SqlServer, but more than 3 minutes on FD (!!!)

What's wrong?

But mooving from BDE (ANSI) to FD on SqlServer, if I'm not wrong, the new driver forces me to use UTF16, that is to physically double the amount of data transferred.
Is there a way to use FD and MSSQL (or maybe ODBC) with UTF8 ?

Hi Uwe, thanks for your reply.
No, I use 50 records paging, as suggested on most of discussion found on the net.

Hi all, I recently migrated from D7 BDE (SqlServer) to D11 FireDac.
All is working just fine, but the performance are getting worse.
Have you got any advice about the better set up? Most of my query are read only select, aming to popolate DbGrid or to save data to other kind of structure.

Thanks in advance

I had the same issue a few times, during the last 10 years.
Everytime the solution was the same: CUT the whole text, PASTE it on notepad, then cut and paste back on Delphi IDE.

This workaround worked for me because there was some tricky char in the text, or maybe there is something incorrect out of nowhere.