UNIDAC VS FIREDAC

[踏雪无痕]

非安卓开发，连接MS SQL，无三层架构为前提
哪个好呢？

UNIDAC是之前为了直连ORACLE而使用的，不需要安装数据库客户端，并且支持delphi所有版本，更新也比较快
最近对cxGrid里面的数据量巨大带来的效率问题，发现SERVER MODE可以解决（也有不支持的功能：例如：自定义排序、editform等），但是对UNIDAC支持不好，看官方论坛有很多对unidac的问题，官方建议使用ADO或者FIREDAC，我想问一下各位大神怎么看这两个控件呢？

[lyhoo163]

我感觉，还是使用DateSnap。 虽然，你提出不使用三层，但我在使用中，单机的用户。直接上三层： 一是，过几天它要三层了，我就不改代码就能使用。 二是，三层的数据库应用比较成熟。 一已之见。

[踏雪无痕]

网上找到一篇文章 Hello, UniDAC has a lot of benefits. Here are some of the most significant ones: - Connection to Oracle, MySQL, PostgreSQL, SQLite, and NexusDB without involving a DB Client library; - Only UniDAC supports connecting to SQLite, Oracle, MySQL, PostgreSQL and InterBase from iOS and Android; - Support for dbMonitor, that allows our users to see all SQL statements, which were sent to a DB server; - Local Failover for connection loss detection and implicit re-execution of certain operations; - Highest performance; - Lesser memory consumption; - Highest stability; - High-quality technical support, that helps our users resolve all their issues as soon as possible; - and others UniDAC has a lot of options that allow to tune performance and behaviour as you want. Devart is in the market for over 16 years and has always been the leader in the field of Data Access Components development, therefore we have never compared our components with competitors. Our competitors usually tried to catch up with us and implement those features, that we already had long time ago. If the feature by feature comparison is interesting for many people, we will probably make such a comparison, but this is a rather time-consuming issue, as every product has a lot of options and features. You can also see independent tests on memory consumption and performance at http://stackoverflow.com/questions/16016700/efficient-database-access-to-various-dbms-from-delphi-xe2/16668452#16668452