Post
by Ikar » Wed 16 Mar 2005 12:43
dbExpress technology serves for most possible unification of accessing different servers (MS SQL, MySQL, Oracle and so on). It is Based on drivers including all specific of working with the certain server. As any universal tool, at the most specific cases dbExpress loses to specialized methods. For example, dbExpress design-time is quite poor and couldn't be expanded.
MyDAC is a specialized set of components to access MySQL Server with advanced design-time, with interface similar to BDE-components.
We tried to implement maximum support of MySQL in MyDAC and DbxMda, but at the last one, dbExpress technology puts restrictions.
MyDAC and DbxMda use the same kernel, as a result they have similar performance.
Verdict: if a possibility to re-build your application fast from using MySQL to another server is important for you, you'd better use DbxMda. At the rest cases, especially on migration from BDE or ADO, you should use MyDAC.