Devart Forums

Hello,
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

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.