Migration BDE to MsDac

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 39
Joined: Thu 17 Apr 2008 13:01

Migration BDE to MsDac

Post by formi » Fri 18 Apr 2008 05:38

I have to migrate severel bde-applications to Sql Server. The applications uses TTable (not TQuery). Is it ok to convert to TMsTable as the wizard does or should I convert to TMsQuery (performance and other subject). I've no experiences with sql-databases but I have to read some books now. Thanks for your answer, Peter

Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 21 Apr 2008 09:16

The TMSTable component is just a wrapper of TMSQuery, so the the performance is the same for the same data. With TMSQuery you can provide more flexible conditions in the query to reduce returned data size (less fields or/and less records). Reducing data size to be transferred increases performance.

Post Reply