smithsson68@gmail.com
Jun 9, 2010
  10298
(2 votes)

Best (and fastest) ways to load items from the Dynamic Data Store

There are essentially 4 ways to load items from the Dynamic Data Store, depending upon what information you have and what you want back in response. Below I am going to detail the methods in (probable) speed order. Note the speed order depends how many items are fetched from the store.

Load

Usage Scenario: Load a single item using its id.

If you have the Identity of an item (or at least it’s Guid part) then this should be by far the fastest way to load a single item.

Example:

Identity id = ObtainId();
DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    MyType obj = store.Load<MyType>(id);
}

If the item is already in the DDS cache then then no database hit is required at all.

Find

Usage Scenario: Load one or more items that directly match one or more name/value pairs, without paging.

Example 1: Single match criteria

DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    IEnumerable<MyType> items = store.Find<MyType>("MyIntProperty", 34);
}

The ids of the matching items will be read from the database and then each item either read from the DDS cache or from the database. This is faster than using Linq because expressions are not used and a direct SQL statement can be generated and executed.

Example 2: Multi match criteria

DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    IEnumerable<MyType> items = store.Find<MyType>
    (
        new Dictionary<string, object>()
        {                    
            {"MyIntProperty", 34},
            {"MyStringProperty", "SomeValue"}
        }
    );
}

Linq (Items)

Usage Scenario: Load one or more items with complex parameter matching and paging. Items can also be projected into new types.

Example:

DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    var query = from item in store.Items<MyType>()
                where item.MyIntProperty > 33 &&
                item.MyStringProperty.Contains("omeval")
                select item;

    IEnumerable<MyType> items = query.Skip(100).Take(25).ToList();
}

The ids of the matching items will be read from the database and then each item either read from the DDS cache or from the database.

LoadAll

Usage Scenario: Load all items from a store without paging

Example:

DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    IEnumerable<MyType> items = store.LoadAll<MyType>();
}

The ids of the matching items will be read from the database and then each item either read from the DDS cache or from the database. If all items are required from a store then this should be marginally faster than using the Linq (Items) methods as LoadAll does not use expressions and a direct SQL statement can be generated and executed.

For loading items back as PropertyBag or types other than the type that was saved see my blog post about Data Container Indifference

Feedback and comments are as always very welcome.

Jun 09, 2010

Comments

Sep 21, 2010 10:33 AM

Very nice to see the different methods.
Is there a way to see all the different datastores that exists?

If you don't want to hardcode the property names like this
store.Find("MyIntProperty", 34);
you could use
store.Find(MembersOf(s=>s.MyIntProperty), 34);

public static class MembersOf
{
public static string GetName(Expression> expr)
{
var node = expr.Body as MemberExpression;
if (object.ReferenceEquals(null, node))
throw new InvalidOperationException("Expression must be of member access");
return node.Member.Name;
}
}

/ Anders Hattestad

Sep 21, 2010 10:33 AM

MembersOf.GetName(s=>s.MyIntProperty)
/ Anders Hattestad

Frederik Vig
Frederik Vig Sep 21, 2010 10:33 AM

@Anders: EPiServer.Data.Dynamic.StoreDefinition.GetAll();

Please login to comment.
Latest blogs
Optimizely SendGrid SMTP host is deprecated

SendGrid is a services for sending email that is included in Optimizely DXP. Previously smtp.episerver.net was the recommended SMTP server to use,...

Tomas Hensrud Gulla | Dec 4, 2022 | Syndicated blog

Hosting Optimizely CMS 12 on Docker Engine

Since Optimizely CMS can now be deployed as a Docker container, here is a demonstration of building, running and scaling an Optimizely CMS 12 site ...

Stefan Holm Olsen | Dec 4, 2022 | Syndicated blog

How to use CacheTagHelper with content areas in Optimizely CMS 12

I might be going out on a limb here - if you have a better solution, feel very free to share it!  Upgrading your Optimizely web application from .N...

Andreas J | Dec 2, 2022

The 1001st Piece in your 1000 Piece Puzzle: .NET Default Interface Functions

I was recently working with a client who wanted a reasonably large subsystem added to Optimizely that would add automated management to their...

Greg J | Nov 28, 2022 | Syndicated blog