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 enter image description here

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

It's about 10 columns of foreign keys and less than 1000 rows. — Oskar Eriksson, Apr 29 '13 at 11:09
Can you provide create scripts for the tables and some sample data? I'm not able to replicate a performance issue with my own test code. — Registered User, May 07 '13 at 20:09
This appears to be a duplicate of http://stackoverflow.com/questions/16169891/lightswitch-is-slow-ado-net-entity-framework-domain-service-wcf-ria-service — Taylor, May 08 '13 at 20:29
It is also duplicated here: http://stackoverflow.com/questions/16393563/lightswitch-bulk-loading-all-requests-into-one-using-a-domain-service — Taylor, May 08 '13 at 20:30
Not just a duplicate post, but a duplicate by the same author. — tommy_o, May 16 '13 at 18:22

score 1 · Answer 1 · answered Dec 07 '15 at 11:28

1

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

answered Dec 07 '15 at 11:28

Subhas Malik

49
4

LightSwitch related data requests optimization

1 Answers1