Skip to main content
M
MichaelXMongeau
Known Participant
June 29, 2010
Question

spreadsheet functions causing 100% CPU usage

  • June 29, 2010
  • 1 reply
  • 1031 views

Running ColdFusion Enterprise 9,0,0,251028 with JVM 1.6.0_14 on a Windows 2003 server.   I am finding that when using <cfspreadsheet> and the spreadsheet functions to build a spreadsheet the server CPU maxes out at 100% while the spreadsheet object is being built.   The spreadsheet is not overly large or complex:  10-15 columns and 400-500 rows.   This behavior is consistent - it happens every time, even when building a simple spreadsheet with 1 column and a few rows.  Is anyone else experiencing this?    Is it a known problem with a fix?  Thank you.

Michael Mongeau

Stratus Technologies

    This topic has been closed for replies.

    1 reply

    M
    MichaelXMongeauAuthor
    Known Participant
    July 12, 2010

    I was able to root cause the excessive CPU usage to a single-CPU virtual machine.  When I ran the same code on dual-CPU virtual machines the CPU usage went to 50-60% but never reached 100% and stayed there as it does on the single-CPU virtual machine.   So there appears to be an issue with JRun and Apache POI on single-CPU machines.  I simply had my system administrator add another CPU to the virtual machine and the problem no longer occurs.

    ilssac
    ilssac
    Inspiring
    July 12, 2010

    If that works for you, fine.

    But what that tells me, is that it is still using up all of a CPU.  Just that it can't use more then one.  So on the dual CPU system, then one CPU goes to 100%, that puts the overall system at 50%.

    M
    MichaelXMongeauAuthor
    Known Participant
    July 12, 2010

    I agree - the problem is obviously not fixed but this workaround allows my development server to function without being brought to its knees by JRun.  In the end it is an issue for Adobe to address.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices