Databases
StackOverflow2013
Postsdbo
POWCF/Silverlight/SQL DB Caching Strategies
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWCF/Silverlight/SQL DB Caching Strategies
    primarykey
    data
    text
    <p>Ok, I have a pretty complex silverlight app that gets its data from a WCF service (asp.net hosted service layer) which in turn calls into a data layer that calls stored procedures in a SQL 2005 DB to extract the needed data. So the round trip goes like this:</p> <p>Silverlight App --> WCF Service --> Data Layer --> DB --> Data Layer --> WCF Service transforms Data Entity into corresponding DTO (Data Transfer Object) or List&lt;> thereof --> Silverlight App</p> <p>Much of the data is highly relational (so it needs to exist in the DB), but it will change infrequently. It seems that I have several choices of locations to cache this "semi-constant" data:</p> <ol> <li>I can cache it in the data layer. My data layer is already set up to use the SQLDependency class and cache the results from a stored procedure call. I think that this is or can be an application level cache.</li> <li>I can cache the resulting DTO in an application level (or session level depending on the call) cache within the WCF service itself. 2(a) I could even take this a step further by serializing the XML for the resulting DTO(s) into a file on the WCF service side so that I could (a) check memory cache, then (b) check file cache and (c) hit the data layer</li> <li>I could do something similar to 2(a) with isolated storage on the client side within the SL app. I could serialize the data to the local isolated storage with a hash (or a moddate or something) and then just make a call to check that.</li> </ol> <p>One more thing to add: I am hosting this WCF service in IIS7 with dynamic compression turned on so that the (often very large and easily compressed) XML response gets gzip-ed. Ideally, it would seem, I would like IIS to cache this gzip-ed result to avoid all the extra processing. I think that it may do this already but I am not sure.</p> <p>I am pretty sure that the final answer to this is some flavor of "it depends", but I would love to hear how others are approaching this. A good tactical recipe of Do X, Test Performance with tool Y, the do Z if needed would be great to have.</p> <p>A few links (I will add to this as I research this):</p> <p><a href="http://weblogs.asp.net/pglavich/archive/2007/08/10/architecture-wcf-services-and-caching.aspx" rel="nofollow noreferrer">WCF Caching Approach</a></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMark
    1. UScaryden
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWCF/Silverlight/SQL DB Caching Strategies
      1. UScaryden
      1. VTFavorite
    2. VO
      singulars
      1. POWCF/Silverlight/SQL DB Caching Strategies
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWCF/Silverlight/SQL DB Caching Strategies
      1. USpencilslate
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload