+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Performance problems if Sitefinity uses Oracle

Performance problems if Sitefinity uses Oracle

5 posts, 0 answered
  1. Rici
    Rici avatar
    1 posts
    Registered:
    27 Jan 2009
    27 Jan 2009
    Link to this post

    Hi,

    We have to use Oracle as the DB server for Sitefinity, and we are experiencing serious performance problems.

    The software we use: Sitefinity 3.5, Windows 2003 Server 64 bit, Oracle 10g Server 10.2.0.1.0 64 bit, ODP.NET Oracle client (also includes the native client).

    1. A simple page based on a template with one placeholder. The served html code is 8 KByte, and the entire communication to the Oracle server is 90 Kbyte.

    2. A page with a complex layout, based on a template with about 20 placeholders. The served html code is 20 KByte, the entire communication to the Oracle server is 400 Kbyte.

    We measured the communication to the Oracle server with Wireshark using the "Follow TCP stream" option. In the TCP stream we can see the html contents that are supposed to be in the placeholders, but strangely they are not only once in the downward stream, but also appear multiple times in the downward and upward stream. (The content seems to be sent back to the Oracle server).

    This overhead causes slow page responses. Two load-balanced frontend web servers, each with 2x4 CPU cores and 8 GB RAM, can serve the simple page only with 10-40 req/sec, and the complex page only with 1-3 req/sec, depending on the degree of concurrency of the test requests.
    If we test the same contents with the corresponding master pages and .aspx pages saved to the file system (without the CMS), the servers can do over 200 req/sec, including the rendering of non-CMS dynamic content.

    Unfortunately the current caching solutions in Sitefinity are not applicable (caching the entire html output), because the html output depends on the currently logged on user and other non-cacheable dynamic controls.

    My suggestion is a caching mechanism, where not the html output is cached in the server's RAM, but the data that is requested from the database. So the ASP.NET page life cycle is executed with every request, the dynamic controls can do their work, but no network IO is required to the DB.

    Thanks for your answers,
    Peter

  2. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    30 Jan 2009
    Link to this post
    Hello Peter,

    Thank you for your feedback and for the detailed explanation of the problems.
    I think they all will be resolved in the upcoming release of Sitefinity, because we improved a lot the caching mechanism. The "substitution controls" is one of the new features, which you could use to render the dynamic controls within the cached output HTML. We already use it for www.telerik.com and it works pretty good.
    We will post more details and examples after the release.

    All the best,
    Vlad
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. Jacques
    Jacques avatar
    427 posts
    Registered:
    28 Jun 2007
    26 Jan 2010
    Link to this post
    Hi Peter,

    We have a somewhat similar situation to yours in that we use Oracle10g with dual web servers, but they're lower spec to yours.

    To my mind I cannot fathom why delivering 40Kb to the browser should take 6 seconds. When I explained this to Sitefinity all I get is vague answers telling me it's the servers. But after extensive investigation (trying to involve Sitefinity) the only thing we can come up with is that Sitefinity itself is the problem. In our traces we found the PreRender even to take up to 16 seconds on pages that contain the news module.

    So far Sitefinity support has been of no help whatsoever and quite frankly both us and our customer are starting to have some serious doubts about Sitefinity.

    I'm the managing director of a company in South Africa and we've just postponed two Sitefinity projects due to their inability to answer questions of performance when it comes to their product. In total we have around 4-6 Sitefinity projects waiting, but we're refusing to go ahead until we start getting some answers from Sitefinity.

    Hope you've found some solutions to your problems.

    Jacques
  4. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    26 Jan 2010
    Link to this post
    Hello J.Hov,

    You have submitted several threads already, and this post is posted an year ago. 

    Please mind that the standard response time is 48 hours, and your tickets will be answered within this frame for sure. Posting more forum threads and support tickets about the same problem might slow us down though..

    Thank you for your understanding.

    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. Jacques
    Jacques avatar
    427 posts
    Registered:
    28 Jun 2007
    26 Jan 2010
    Link to this post
    Hi Georgi,

    Thank you for answering so quickly.

    The fact that this issue was raised a year ago makes it all the more relevant since performance is still a massive issue. And, so far Sitefinity support have given me nothing but superficial guidance on what to do.... All of it avoiding the fact that these performance issues are coming from Sitefinity, not Asp.net, not Oracle, not the servers.

    For the record, during our first implementation for this same client we also had performance issues to which Sitefinity were also not able to help much. This is not 48 hours, we've been dealing with this for months now.

    Jacques
Register for webinar
5 posts, 0 answered