20

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 allenter 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

Oskar Eriksson
  • 845
  • 1
  • 9
  • 28

1 Answers1

1

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