spreadsheet functions causing 100% CPU usage

[MichaelXMongeau]

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

[MichaelXMongeau]

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]

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%.

[MichaelXMongeau]

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.