New Posts New Posts RSS Feed: Painfully Slow and Large Queries
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Painfully Slow and Large Queries
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
oldie View Drop Down
Newbie
Newbie


Joined: 07-Jan-2009
Location: UK
Posts: 5 		Post Options Post Options   Quote oldie Quote  Post ReplyReply Direct Link To This Post Topic: Painfully Slow and Large Queries
    Posted: 13-Feb-2009 at 6:52am
I wondered if anyone has been experiencing this problem. I have a hierarchy of 4 layers of inheritance which roughly has 2-5 branches per layer. I'm using inheritance by Table-Per-Type. On first querying the data a straight forward query to return <OfType> of the bottom layer is taking at least 8 seconds to return about 10 objects.
Using the SQL Profiler, I notice that the query is very large, (about 8000 lines, half a million characters according to word!!)
 
I'm guessing the delay is caused by the Entity Framework rather than DevForce, just wondered if it's worth investing the time in Table-Per-Hierarchy or stored procedures.
 
Any suggestions
 
SQL2005
Defvorce EF 4.2.2
Visual Studio 2008 SP1
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Posted: 18-Feb-2009 at 10:28am
I suspect that you are correct in surmising that slow performance by DevForce EF is due to slow performance by the Entity Framework. To verify this suspicion, you would have to write two versions of your application, one with DevForce EF and one without DevForce EF that just used the Entity Framework.

Edited by davidklitzke - 18-Feb-2009 at 10:29am
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down