TMSSQL vs TMSQuery

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
bdkacz
Posts: 5
Joined: Sat 19 Nov 2016 20:19

TMSSQL vs TMSQuery

Post by bdkacz » Sat 19 Nov 2016 20:22

Hi

What is the adventage of using TMSSQL in place of TMSQuery for INSERT,UPDATE statements ?

Best regards
Bartosz

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: TMSSQL vs TMSQuery

Post by azyk » Wed 23 Nov 2016 13:29

You can use TMSSQL instead of TMSQuery to execute SQL queries which do not return a result.

In some cases the advantage to use TMSSQL instead of TMSQuery can be execution time of run-time code processing INSERT/UPDATE SQL queries. For example, the difference can become significant when executing a large number of such SQL queries.

Take into account that advantages to use TMSSQL instead of TMSQuery depend on each particular case: on business-logic, specific requirements to user application, etc.

Post Reply