Craig Stuntz [TeamB]
2007-11-28 14:21:13 UTC
I use UpdateMode = upWhereKeyOnly and I'm pretty sure the database
uses the PK index to locate records faster, even if GetMetadata is
false.
TSQLDataSet could use the metadata info to determine whichuses the PK index to locate records faster, even if GetMetadata is
false.
column(s) are in the PK when constructing its SQL. But you can't always
determine this from the DB (e.g., with a VIEW), and you can manually
specify it with pfInKey if you have persistent TFields anyway.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
How to ask questions the smart way:
http://www.catb.org/~esr/faqs/smart-questions.html
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
How to ask questions the smart way:
http://www.catb.org/~esr/faqs/smart-questions.html