Stef Merlijn
asked on
Conversion ADO to FireDAC
Hi,
With the new Delphi XE7 I would like to investigate if moving from ADO to FireDAC is a wise discission.
I'm using currently a MS SQL Server 2008 R2 SP2 database.
Does anybody have any experience with this merger?
Will this increase performance and stability (which might make it worth the effort)?
Is there some automation possible for existing project with lots of ADO-components?
Thanks!
With the new Delphi XE7 I would like to investigate if moving from ADO to FireDAC is a wise discission.
I'm using currently a MS SQL Server 2008 R2 SP2 database.
Does anybody have any experience with this merger?
Will this increase performance and stability (which might make it worth the effort)?
Is there some automation possible for existing project with lots of ADO-components?
Thanks!
ASKER
As I read the article, it looks like FireDAC 's speeds partly comes from the fact that it loads only 50 records at a time (based om OnDemand-setting). I've implemented such mechanism with ADO too, by fetching only f.e. TOP (50) records.
Memory table I already have from DevExpress. Or does FireDAC support some different type of memory management?
Memory table I already have from DevExpress. Or does FireDAC support some different type of memory management?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've asked Embarcadero as well, but they don't seem to have much experience in migration from ADO to FireDAC.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Geert I completely agree.
They seem to be fixated on creating new stuff, but spend less time on making the product bug-free. Some bugs are there in version after version.
They seem to be fixated on creating new stuff, but spend less time on making the product bug-free. Some bugs are there in version after version.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://edn.embarcadero.com
Mida conversion tool can convert Ado to FireDac. But in basics - this is all the same. You can build some little test tools for speed comparison and see by yourself what is best for you. If you need memory table - then use FireDac - but for older projects - I would go with ado on.
Here is what other say about migration.