DevForce Community Forum : Painfully Slow and Large Queries http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Painfully Slow and Large Queries Sat, 11 Apr 2026 19:46:00 -700 Wed, 18 Feb 2009 10:28:39 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1094 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Painfully Slow and Large Queries : I suspect that you are correct... http://www.ideablade.com/forum/forum_posts.asp?TID=1094&PID=3923#3923 Author: davidklitzke
Subject: 1094
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]]> Wed, 18 Feb 2009 10:28:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1094&PID=3923#3923 Painfully Slow and Large Queries : I wondered if anyone has been... http://www.ideablade.com/forum/forum_posts.asp?TID=1094&PID=3914#3914 Author: oldie
Subject: 1094
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
]]> Fri, 13 Feb 2009 06:52:09 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1094&PID=3914#3914