Print Page | Close Window

Painfully Slow and Large Queries

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2009
Forum Discription: For .NET 3.5
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1094
Printed Date: 26-Apr-2025 at 8:45pm


Topic: Painfully Slow and Large Queries
Posted By: oldie
Subject: Painfully Slow and Large Queries
Date 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


Replies:
Posted By: davidklitzke
Date 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.


Print Page | Close Window