which is better for master-detail relation?

mighty · Post by **mighty** » Fri 23 Jun 2006 08:34

I want to make a master-detail relation.

Before IBDAC, I was using a SQL such as "select * from detail where detid =:masid" for master-detail relation.

So. Should I keep to use this way or dataset's masterfields property.

Which is the better way for performance?

Alex · Post by **Alex** » Fri 23 Jun 2006 12:09

Your approach is fully supported by IBDAC, but it is better to set up Master-Detail using MasterField and DetailField property. This will allow you to get MasterField value automatically and give some performance boost. Also I recommend to pay attention to TIBCDataSet.Options.DetailDelay property,which could be helpful in case of huge detail data.