TUniTable or TUniQuery ?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Tsagoth
Posts: 33
Joined: Wed 15 Jul 2009 01:25

TUniTable or TUniQuery ?

Post by Tsagoth » Thu 11 Apr 2013 15:43

Does TUniTable work with the underlying table directly or does it just convert each operation into SQL statements such that I would be better off just using TUniQuery directly ?

I ask because often the examples given here show an SQL statement for the SELECT and then instead of using an Update will be shown a .Edit, fieldbyname = someval, .post operation. It makes me wonder if the table methods are a little faster than using SQL statements. But if TUniTable just calls TUniQuery under the covers then no reason to use it for that.

DemetrionQ
Devart Team
Posts: 271
Joined: Wed 23 Jan 2013 11:21

Re: TUniTable or TUniQuery ?

Post by DemetrionQ » Fri 12 Apr 2013 12:37

Hello.

TUniTable and TUniQuery originates from one basic class. All update/display data operations with TUniTable are converted to SQL queries with no performance advantages. TUniQuery is able to completely replace TUniTable.
TUniTable is convenient in case of working with one table.

Post Reply