I'm working in an old Delphi 7 project and trying to get my bearings in it. I had heard that TADOTables are bad because they pull down entire tables. However I am looking at one bit of code and I'm wondering if it does the same thing. All it does is set the values of some fields and then do tbl.Post
and possibly does the tbl.Insert
command before it if applicable. (sorry, I'm not the most experienced in Delphi)
Anyway, so should TADOTables be completely phased out or should they only be replaced when doing select *
statements from them practically a开发者_如何学JAVAnd they're OK for inserts and updates?
ADOTables have to pull most (or all, depending on configuration) data from the server, so you're loading many rows of data simply to do an insert/edit and post.
Unless you're dealing with small, local databases (eg., Access database on the local machine), you're better off getting away from table-based data and moving to INSERT/UPDATE set-based operations.
精彩评论