Daniel Ovaska
Aug 10, 2009
(1 votes)

Xforms performance


The main issue is that the XFormSelect.aspx does a lot of database calls to load each xform. You can check the bug #25759: EPiServer.UI.Edit.XFormSelect.LoadForms calls GetxFormUsedonPages twice per xform on each request.

The problem is that GetxFormUsedonPages results in a call to the FindPagesByCriteria method. If you haven’t been warned about using that method extensively, you should have been. So the bottom line is that if you have 200 xforms this will result in 2*200=400 FindPagesByCriteria calls every time the popup is opened / paged / filtered which hammers the database badly and can result in deadlocks. Response time at worst for me was around 120 seconds which causes a timeout error.


Warning: This solution modifies some files in the episerver UI folder. This will have to be redone after upgrading episerver. If possible, wait until episerver implements some similar solution. I did not have that option with a lot of angry editors on my back. If you do not have the privilege of time, feel free to use my workaround.

  1. Locate and backup the modified UI files (XFormSelect.aspx, XFormSelect.ascx, XFormEdit.aspx)
    These are usually found at C:\Program\EPiServer\CMS\5.2.375.133\Application\UI\Edit when doing a standard install.
  2. Replace the files above with the
  3. Add some logging, change namespaces etc to fit your needs.
  4. Add these files and their code behind files (.cs) to your solution. 
  5. Add the XFormManager.cs to your solution.
  6. Open your Global.asax and add the following lines:
    a)  If you haven't added some page events. Do it…
    protected void Application_Start(Object sender, EventArgs e)
        EPiServer.DataFactory.Instance.CreatedPage += 
    new PageEventHandler(onCreatedPage); EPiServer.DataFactory.Instance.DeletedPage +=
    new PageEventHandler(onDeletedPage); EPiServer.DataFactory.Instance.SavedPage +=
    new EPiServer.PageEventHandler(OnSavedPage); }
    b) Add event handlers if you don’t have any. 
    private void onDeletedPage(object sender, PageEventArgs e)
       PageData deletedPage = 
    EPiServer.DataFactory.Instance.GetPage(e.PageLink); InvalidateXFormCache(deletedPage); } private void OnSavedPage(object sender, EPiServer.PageEventArgs e) { PageData updatedPage =
    EPiServer.DataFactory.Instance.GetPage(e.PageLink); InvalidateXFormCache(updatedPage); } private void onCreatedPage(object sender, PageEventArgs e) { PageData createdPage =
    EPiServer.DataFactory.Instance.GetPage(e.PageLink); InvalidateXFormCache(createdPage); }
  7. c) Add private helper function to invalidate xforms cache for that page.
    private void InvalidateXFormCache(PageData page)
           foreach (PropertyData prop in page.Property)
              if (prop.Name == "XForm")
                 if (prop.Value != null)
                      string formid = prop.Value.ToString();
                      if (!string.IsNullOrEmpty(formid))
                         string cacheKey = "xFormUsedonPages" + formid;
         catch (Exception ex)
             //Do some logging with log4net for example
  8. Build and try it out and add a comment on this blog


To solve the bad performance with xforms selection and the deadlocks in the database this can cause I added caching in a helper class (XFormsManager) and redirected the calls from XFormSelect.ascx and XFormEdit.aspx to use this class instead. This reduced the response time from 120 seconds to a few ms. As the XFormSelect page also displays which pages use which form, I added eventhandlers to Global.asax to ensure that these text were updated.

Aug 10, 2009


Sep 21, 2010 10:32 AM

Nice work
/ Anders Hattestad

Magnus Rahl
Magnus Rahl Sep 21, 2010 10:32 AM

Question: You tagged this with CMS 5 R2 SP1, is that correct? A customer seems to have encountered this problem when upgrading to SP2, it was fine in SP1.

Sep 21, 2010 10:32 AM

Magnus: Yes that is correct. This problem was noticed when upgrading from 5.1 SP2 to 5 R2 SP1. If you should happen to find a true fix to the database issue rather then curing the symphoms with caching, feel free to let me know about it :)
/ Daniel

Sep 21, 2010 10:32 AM

I get an error when I try to edit a form and choose the "edit and save" button. If I edit and just save it works.

Jun 18, 2015 08:52 AM

The bad performance I talk about in this case with Xforms has been fixed with EPiServer 6 and is no longer an issue. 

Please login to comment.
Latest blogs
Plug-in manager is back in CMS 12

Plug-in manager is back in the UI, what is it and how can i use it?

Luc Gosso (MVP) | Oct 6, 2022 | Syndicated blog

Display Child Pages in Content Delivery API Response

The below example will implement an instance of IContentConverterProvider to customise the serialisation of PageData and output child pages in the...

Minesh Shah (Netcel) | Oct 4, 2022

Bring the Report Center back in Optimizely CMS 12

The Report Center has been a part of Optimizely CMS since its first debut in version 5R2 in 2008, but in CMS 12, it's removed! Don't despair! Make...

Tomas Hensrud Gulla | Oct 4, 2022 | Syndicated blog

Customizing Property Lists in Optimizely CMS

Generic property lists is a cool editorial feature that has gained a lot of popularity - in spite of still being unsupported (officially). But if y...

Allan Thraen | Oct 2, 2022 | Syndicated blog