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?
which is better for master-detail relation?
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.