performance with localmasterdetail option

[inageib]

Hi,
I have a detail table for invoices has 100,000 records and counting up so at the end of the year will be millions. I read about localmasterdetail option on the help file and tried to use it to reduce calls to the server but I want to ask does loading time when I open the table will be increased a lot when I have one million record or more ?

does using localmasterdetail master detail for such table is recommended ?

Thanks

[AndreyZ]

Hello,

Setting the LocalMasterDetail option to True is not recommended when detail table contains too many rows, because when it is set to False, only records that correspond to the current record in master dataset are fetched. When LocalMasterDetail is True, all records from the detail table are fetched to the client.

[inageib]

So for tables has alots of rows setting LocalMasterDetail to true will increase loading time but will be lighter on the network ?

[AndreyZ]

Yes.

[inageib]

Thanks

[AndreyZ]

If any other questions come up, please contact us.