DevForce Community Forum : Forcing Includes to come from cache http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Forcing Includes to come from cache Wed, 29 Jul 2026 06:11:51 -700 Thu, 21 Oct 2010 10:55:26 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2248 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Forcing Includes to come from cache : But when I leave it off the include... http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8874#8874 Author: alindzon
Subject: 2248
Posted: 21-Oct-2010 at 10:55am

But when I leave it off the include this is what happend even though its in cache.
I cam send you the entire trace, but here is the key piece.
SELECT
[Extent1].[ManID] AS [ManID],
[Extent1].[ManName] AS [ManName],
[Extent1].[Synonyms] AS [Synonyms],
[Extent1].[Display] AS [Display],
[Extent1].[Srch] AS [Srch],
[Extent1].[ProdCount] AS [ProdCount]
FROM [dbo].[Manufacturers] AS [Extent1]
WHERE 101424 = [Extent1].[ManID]
 
This occurs for each and every line in the gridview. 
 
But if I load up a manufacturer screen with just manufacturers in the grid there are NO database accessses at all.
 
 
]]> Thu, 21 Oct 2010 10:55:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8874#8874 Forcing Includes to come from cache : alindzon, since the Manufacturers... http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8873#8873 Author: kimj
Subject: 2248
Posted: 21-Oct-2010 at 10:46am

alindzon, since the Manufacturers are already in cache you don't need to, and actually shouldn't, use the Include when you query Products.   DevForce won't resolve part of the query from the database and part from cache - the entire query with the Include will go to the database if the entire query can't be satisfied from cache.   You'd use the Include when you didn't already have Products loaded, to bring in the object graph of Products and Manufacturers.]]> Thu, 21 Oct 2010 10:46:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8873#8873 Forcing Includes to come from cache : Then perhaps you have something... http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8852#8852 Author: midnit
Subject: 2248
Posted: 20-Oct-2010 at 8:05am

Then perhaps you have something set so it wont use cache. It does work, we have over 13 joins that never happen due to the cached data already existing.



Edited by midnit - 20-Oct-2010 at 8:07am]]> Wed, 20 Oct 2010 08:05:41 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8852#8852 Forcing Includes to come from cache : I tried that before I added the... http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8851#8851 Author: alindzon
Subject: 2248
Posted: 20-Oct-2010 at 7:51am

I tried that before I added the include, and not only was the database accessed, but it was accessed one entry at a time.  i.e. each row on the datagrid resulted in a single query to the database.
 
So I am afraid that did not work.
 
What I did in the xaml was I put in Manufacturer.ManName as the field to display.
 
 
]]> Wed, 20 Oct 2010 07:51:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8851#8851 Forcing Includes to come from cache : Basically you have to do nothing. If... http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8850#8850 Author: midnit
Subject: 2248
Posted: 20-Oct-2010 at 7:47am

Basically you have to do nothing.
 
If the navigation property's item is in cache it will wire it up for you. So remove your includes for the items you already have in cache. Thats assuming you mean you already queried and the data is cached in the same entitymanager.
]]> Wed, 20 Oct 2010 07:47:25 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8850#8850 Forcing Includes to come from cache : I think this is a simple question.... http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8849#8849 Author: alindzon
Subject: 2248
Posted: 20-Oct-2010 at 6:10am

I think this is a simple question.  I am keeping the entire manufacturer list in cache, which is working perfectly when I query against it.

I have a product table which is NOT in cache, and I am accessing it one page at a time.
 
Every time I retrieve a page of products, I need to substitute the ManName for the ManID which is in the product file, for the view.  i.e. I show Manufacturer.ManName which is related by the ManID.
 
I want to compose the query in such a way that the ManName comes from cache and not from a join.
 
I have about 5 tables I am keeping in cache because they are constantly needed as a resource, and there is no need to keep hitting the database.
 
 
]]> Wed, 20 Oct 2010 06:10:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2248&PID=8849#8849