Jump to content

mario.arosio@gmail.com

Members
 View Profile  See their activity

  • Content Count

    7

  • Joined

  • Last visited

Everything posted by mario.arosio@gmail.com

  1. mario.arosio@gmail.com

    FireDAC performances

    mario.arosio@gmail.com posted a topic in Databases

    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
  2. mario.arosio@gmail.com

    FireDAC performances

    mario.arosio@gmail.com replied to mario.arosio@gmail.com's topic in Databases

    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
  3. mario.arosio@gmail.com

    FireDAC performances

    mario.arosio@gmail.com replied to mario.arosio@gmail.com's topic in Databases

    ... 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
  4. mario.arosio@gmail.com

    FireDAC performances

    mario.arosio@gmail.com replied to mario.arosio@gmail.com's topic in Databases

    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?
  5. mario.arosio@gmail.com

    FireDAC performances

    mario.arosio@gmail.com replied to mario.arosio@gmail.com's topic in Databases

    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 ?
  6. mario.arosio@gmail.com

    FireDAC performances

    mario.arosio@gmail.com replied to mario.arosio@gmail.com's topic in Databases

    Hi Uwe, thanks for your reply. No, I use 50 records paging, as suggested on most of discussion found on the net.
  7. mario.arosio@gmail.com

    Debugger activates breakpoint - do not understand yet why

    mario.arosio@gmail.com replied to Daniel's topic in Delphi IDE and APIs

    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.
×