Got a weird problem. I am using linq2umbraco with umbraco 452 (.net 40) on a page and the context is rebuilt each time that page is hit e.g
WoiDataContext _woiContext = new WoiDataContext();
I recall from some tweets a couple of weeks ago from Slace that you should use singleton pattern for your linq2umbraco context.
So I updated my code and am using singleton and caching my linq2umbraco context. I also have action handlers for publish / unpublish which removes the linq2umbraco context from cache. Singleton code looks like
public partial class WoiDataContext
{
const int ValueCacheTime = 86400;
public const string ContextCacheKey = "WOIContext";
public static WoiDataContext Instance
{
get
{
if (UmbracoContext.Current.InPreviewMode)
{
var previewContent = new PreviewContent(new Guid(umbraco.BusinessLogic.StateHelper.GetCookieValue("PreviewSet")));
var path = previewContent.PreviewsetPath;
return new WoiDataContext(new NodeDataProvider(path, true));
}
//using http://aspalliance.com/1705_A_New_Approach_to_HttpRuntimeCache_Management.all to cache
return TCache<WoiDataContext>.Get(ContextCacheKey, ValueCacheTime,() => new WoiDataContext());
}
}
public static void RemoveLinq2UmbracoContextFromCache()
{
TCache.Update(ContextCacheKey);
}
}
when i run the website locally (iis7.5) the item is added to cache i can see it in umbraco cache browser. When i run the site on dev server (iis6) it does not cache. I dont get any errors and site still runs. This is really really weird.
I checked the dlls on the dev server and my caching code is definately deployed. For some strange reason its just not caching.
I was very interested to ready this post as I'm trying to implement something very similar, except I'm using the multithreaded singleton pattern.
Anyway the problem I'm getting is when I create a new instance of my DataContext it's created in a nanosecond, but it seems there's a process in the background that actually populates the object graph, as there is no data in the object at this point.
If I run a linq query when this is going on, all I have is an empty instance of the DataContext with no data? The net result is that each time I refresh the data, users of the website get errors until the DataContext gets all the data, which can take up to 20 secs on my site.
I've also tried the NodeDataProvider "Flush" method but this is unreliable, it only seems to work 60% of the time.
I did solve my problem - by ripping out the LinqToUmbraco and using Sql Server instead :-D
Umbraco is a very good CMS but it's not designed to handle lots of data, so if you're having long loading times maybe you have too much data for Umbraco to handle? In these cases we use Sql Server with a custom section in the Umbraco admin system to manage the data.
thank you for your reply. We rely heavily on LinqToUmbraco to generate strongly-typed objects as well as for the data retrieval itself. And I would really like to continue having the strongly-typed objects.
We are creating a site where users can update their profile. But because of the large amount of data, whenever a profile is changed by the user, the entire datacontext has to be reloaded, which can take up to 2 minutes, which is quite bad for the user experience.
Are there any other ways of creating strongly-typed objects in umbraco or make LinqToUmbraco faster with a lot of data ?
IMO LinqToUmbraco is unuseable for that very reason, but it may have been updated since I last used it. I use razor templates now where you get strongly typed objects by default.
For example if you have a Profile document type with 3 properties; FirstName, LastName, Email; on your page you accesss that data using with the following c# code; @Model.FirstName, @Model.LastName, @Model.Email. Likewise you can access any document or multiple documents from any page in your site.
I also use my strongly typed objects in the business layer. As far as I know that is not possible with Razor, since it is a rendering engine, or am I mistaken.
You are probably right. Since I already have all my "objects" setup as doctypes in umbraco, is there an easy way to create strongly-typed objects using sql and the umbraco db ? Or should I avoid umbraco all together and use custom tables ?
Singleton caching linq2umbraco context
Guys,
Got a weird problem. I am using linq2umbraco with umbraco 452 (.net 40) on a page and the context is rebuilt each time that page is hit e.g
I recall from some tweets a couple of weeks ago from Slace that you should use singleton pattern for your linq2umbraco context.
So I updated my code and am using singleton and caching my linq2umbraco context. I also have action handlers for publish / unpublish which removes the linq2umbraco context from cache. Singleton code looks like
public partial class WoiDataContext { const int ValueCacheTime = 86400; public const string ContextCacheKey = "WOIContext"; public static WoiDataContext Instance { get { if (UmbracoContext.Current.InPreviewMode) { var previewContent = new PreviewContent(new Guid(umbraco.BusinessLogic.StateHelper.GetCookieValue("PreviewSet"))); var path = previewContent.PreviewsetPath; return new WoiDataContext(new NodeDataProvider(path, true)); } //using http://aspalliance.com/1705_A_New_Approach_to_HttpRuntimeCache_Management.all to cache return TCache<WoiDataContext>.Get(ContextCacheKey, ValueCacheTime,() => new WoiDataContext()); } } public static void RemoveLinq2UmbracoContextFromCache() { TCache.Update(ContextCacheKey); } }when i run the website locally (iis7.5) the item is added to cache i can see it in umbraco cache browser. When i run the site on dev server (iis6) it does not cache. I dont get any errors and site still runs. This is really really weird.
I checked the dlls on the dev server and my caching code is definately deployed. For some strange reason its just not caching.
Any ideas?
Regards
Ismail
This seems to be iis6 issue. I deployed my dll to live iis7.5 site and it works the context is cached. Bizarre!!!
Regards
Ismail
Hi Ismail,
I was very interested to ready this post as I'm trying to implement something very similar, except I'm using the multithreaded singleton pattern.
Anyway the problem I'm getting is when I create a new instance of my DataContext it's created in a nanosecond, but it seems there's a process in the background that actually populates the object graph, as there is no data in the object at this point.
If I run a linq query when this is going on, all I have is an empty instance of the DataContext with no data? The net result is that each time I refresh the data, users of the website get errors until the DataContext gets all the data, which can take up to 20 secs on my site.
I've also tried the NodeDataProvider "Flush" method but this is unreliable, it only seems to work 60% of the time.
I'd be grateful for any thoughts.
Thanks
Harv
Hi Harv
did you resolve the problem ? I am having similar issues with long loadtimes (in my case up to 2 minutes because I have a lot of nodes).
thanks
Thomas
Hi Thomas,
I did solve my problem - by ripping out the LinqToUmbraco and using Sql Server instead :-D
Umbraco is a very good CMS but it's not designed to handle lots of data, so if you're having long loading times maybe you have too much data for Umbraco to handle? In these cases we use Sql Server with a custom section in the Umbraco admin system to manage the data.
Here's how to make the custom sections:
http://www.geckonewmedia.com/blog/2009/8/3/how-to-create-a-custom-section-in-umbraco-4
Cheers
H
Hi Harv
thank you for your reply. We rely heavily on LinqToUmbraco to generate strongly-typed objects as well as for the data retrieval itself. And I would really like to continue having the strongly-typed objects.
We are creating a site where users can update their profile. But because of the large amount of data, whenever a profile is changed by the user, the entire datacontext has to be reloaded, which can take up to 2 minutes, which is quite bad for the user experience.
Are there any other ways of creating strongly-typed objects in umbraco or make LinqToUmbraco faster with a lot of data ?
thanks
Thomas
IMO LinqToUmbraco is unuseable for that very reason, but it may have been updated since I last used it. I use razor templates now where you get strongly typed objects by default.
For example if you have a Profile document type with 3 properties; FirstName, LastName, Email; on your page you accesss that data using with the following c# code; @Model.FirstName, @Model.LastName, @Model.Email. Likewise you can access any document or multiple documents from any page in your site.
Here are some tutorials on razor:
http://our.umbraco.org/wiki/reference/code-snippets/razor-snippets
Thanks
H
Hi H,
I also use my strongly typed objects in the business layer. As far as I know that is not possible with Razor, since it is a rendering engine, or am I mistaken.
thanks
Thomas
Yes you're correct about razor.
It seems to me you should be using Sql Server for this part of your project, Umbraco is not designed to store lots of data as it's just a CMS.
You are probably right. Since I already have all my "objects" setup as doctypes in umbraco, is there an easy way to create strongly-typed objects using sql and the umbraco db ? Or should I avoid umbraco all together and use custom tables ?
thanks
Thomas
is working on a reply...