More in this section

Forums / Developing with Sitefinity / Performance issue

Performance issue

7 posts, 1 answered
  1. Anthony Smith
    Anthony Smith avatar
    34 posts
    Registered:
    08 Dec 2009
    06 Jan 2010
    Link to this post
    Hi Sitefinity,

    I have a local implementation of 3.6 which has quite a lot of images in the image module, however as a consequence the solution now takes a significant amount of time load. Essentially it runs the following command time and time again, only with a different like property i.e.

    select ControlID, Name, Value FROM sf_CmsControlProperty  where Name='Content' and Value LIKE '%Libraries/Images/post-middle-Template%'

    Each time it runs this command the reads are 6706, which is also very large.

    Why does it do this and is there a way to stop or improve the performance on this?

    Thanks
    Anthony


  2. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    06 Jan 2010
    Link to this post
    Hello Anthony Smith,

    Thank you for contacting us. 

    We had such issue in the 3.6 versions - there is a code in one of the providers, that should fix all links in the content items. The problem here is that this code is run on every application start, rather than just once. The issue is resolved in Sitefinity 3.6SP2 but we will advise you to upgrade to our latest version.

    We apologize for the inconvenience. 

    Best wishes,
    Georgi
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
    Answered
  3. Anthony Smith
    Anthony Smith avatar
    34 posts
    Registered:
    08 Dec 2009
    06 Jan 2010
    Link to this post
    Thanks Georgi,
    I see, what does it fix?

    As the thing is i think i am using 3.6 sp2 do you mean 3.7?

    Also in the later versions if this isnt hit on application start when is it hit? i.e. when can i expect this delay to happen?

    Thanks
    Anthony
  4. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    06 Jan 2010
    Link to this post
    Hi Anthony Smith,

    Can you please let us know about the built number of your project, by following this KB article - http://www.sitefinity.com/support/kb/sitefinity-3-x/how-to-check-your-current-sitefinity-version.aspx

    This had to be fixed in the last service pack of 3.6. On the other hand, we always recommend the latest version.

    Best wishes,
    Georgi
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  5. Anthony Smith
    Anthony Smith avatar
    34 posts
    Registered:
    08 Dec 2009
    06 Jan 2010
    Link to this post
    The version says 1936
  6. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    07 Jan 2010
    Link to this post
    Hello Anthony Smith,

    This is strange. 

    The query you have provided is called only when the database is upgrading. Do you by any reason have another project, tied with the same database? More over, the another project should be downgrading the database, and your SP2 should be performing upgrades every time the database is changed. 

    Sincerely yours,
    Georgi
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  7. Anthony Smith
    Anthony Smith avatar
    34 posts
    Registered:
    08 Dec 2009
    07 Jan 2010
    Link to this post
    Sorry my mistake i was using an older version.

    Thanks for your help
Register for webinar
7 posts, 1 answered