Question about getting the best performance out of MSSQL

Data Abstract
1

Can I pick someone’s brain with regards to database performance?

We’re using a MS SQL Server database which I’m currently connecting to via ADO using the Native Client OLEDB driver. This all seems to work well but I’m wondering whether I could be getting better performance?

I remember reading a while ago about AnyDAC and how it was designed to work very well with DA. Alas it appears that AnyDAC is no longer available as a separate product, having been bought by Embarcadero. It appears that this is now offered as part of Delphi XE4 but renamed to FireDAC.

My first question is, does DA work with “FireDAC” as it’s now called or only the older AnyDAC? If it does then does FireDAC with MSSQL offer any significant performance benefit over ADO? Are there any other advantages or disadvantages?

If there’s a benefit to using FireDAC then I’m open to upgrading in order to get hold of it (currently using Delphi 2010) but obviously don’t want to do so if there’s no real point.

Would appreciate any input or advice :slight_smile:

2

Hello,

FireDAC is completely supported by DA.
Read about AnyDAC performance here:
http://www.da-soft.com/anydac/data-access-performance.html

3

Thanks, looks very interesting/promising.

I tried downloading the trial of XE4 to have a play but unfortunately it seems the RO software won’t install properly, probably because it’s a trial of Delphi rather than a full licensed copy - is this the case?

4

Hello,
What error do you get? Can you provide “\RemObjects Software\Data Abstract for Delphi\log.html” file?

5

It’s on my home machine - I’ll try a fresh reinstall of the RO software over the weekend a grab the log file.