Page 1 of 1
TMSSQL vs TMSQuery
Posted: Sat 19 Nov 2016 20:22
by bdkacz
Hi
What is the adventage of using TMSSQL in place of TMSQuery for INSERT,UPDATE statements ?
Best regards
Bartosz
Re: TMSSQL vs TMSQuery
Posted: Wed 23 Nov 2016 13:29
by azyk
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.