LightSwitch related data requests optimization

Question

I have a SQL Server 2008 table with a lot of foreign keys, when opening this in a screen it takes very long time to load all related data, like 10 seconds... Here's a chart from Fiddler showing loading time, not acceptable at all

I'm using Eric Erhardt's technique for creating a Domain Service and load data through. My question is if I somehow can optimize these numbers? I don't understand why it has to be one request per related data, when just making a normal entity without a domain service all related data loads in one request.

Thanks

Answer 1

Use Unique Clustered Index on the foreign key(S). This will defiantly optimize load, read, fetch performance of SSMS.