query on odata get query in View tables

[prashanthi1]

Hi,

We have a view table which is a join of 7-8 source tables. This table has 10 child tables.

I would like to know if the time taken to generate odata get response would be decreased if i remove the parent child relationships.(parent table odata response would not have any urls of its child tables.)

Thanks in advance,

Prashanthi.

[rareddy]

If you are just querying the view through the OData layer with out $expand, or "atom" format or json with "full-metadata", the child tables are not going to be in the payload. So, I do not think it will affect that much if you remove the relationships.