Devart Forums

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?

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.