FiveTech Support Forums

Dear All,

I've a plan to move to MySql but I'm not quite sure about this.

What difference between ADO and TMySql?

What is the Advantage and DisAvantage between ADO and TMySql?

Sorry, if this topic has been discussion.

Regards,
Dutch

dutch,

ADO requires a client to be installed on the machines you install your system, moreover, to use pure direct SQL statements. With no need for customers tmysql connection, then using the API directly from mysql and you can use features like FIELDPUT, FIELDGET, fieldname, fieldpos.

Dutch,

If your apps will only run on Windows, then I would say ADO is a good choice as you will be able to work with different databases engines, and theoretically your code will be almost the same. In practice we have seen that there are differences between diferent databases engines even if they use ADO. I have never compared the speed between ADO and direct TMySQL, so I don't know if that could be a point to consider also.

If you ever think to migrate your app to Linux or OSX, there is no ADO there, so then better use a direct connection to a database engine like TMySQL. I don't think there is an ADO for Linux, at least it would be based on Mono. Anyhow, I have never tested it.

Dear William and Antonio,

Thanks for your kind explanation. The point which I need to understand is speed and data source compatible.

If I need to use difference data source, The ADO is the choice but the coding are not much difference. It need ODBC on client PC with pure sql statement.

If I need to use MySql only, The TMySql is the choice, because no need ODBC at client PC and I can use the feature as William said. But change the data source, it will be the big change again.

I cannot search the speed test for both engine in the forum. I think TMySql is better than ADO because it no need to connect ODBC.

Do I understand correctly?

Dutch,

Maybe the speed is not an issue here as ADO is also very fast, but obviously without ODBC and ADO, I also think it has to be faster