when should I use options.autoprepare=true ?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
luis_augusto
Posts: 43
Joined: Fri 14 Oct 2005 13:45

when should I use options.autoprepare=true ?

Post by luis_augusto » Thu 31 Aug 2006 13:21

According to the manual, by setting options.autoprepare = true, performance would be improved specially in cases where there is a master-detail relationship. My question is:

Should I setup this property in the master or in the detail table (or both)?

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Thu 31 Aug 2006 15:22

In Master/Detail relationships detail query is usually executed several times to refresh detail data.
So there is sense to set AutoPrepare = True in detail query.

Post Reply