From: Greg Lorriman <temp@...>
Date: 2006-01-25T06:18:12+09:00
Subject: Re: slowness of WIN32OLE.rb in 1.8.2 - faster in 1.8.4?

>if you just create an excel object without also creating another sub
object to manipulate a specific sheet or range of cells it could be a
little slower.

I was aware of that, and so all my code immediately assigns to the
nearest object. For example :

wb=excel.workBooks.load("something.xls");
ws=wb.sheets("somesheet");
ws.range('a1:a100').value.each { |cell| something; };

and I'll continue using wb,ws and the arrays from the "range" calls as
appropriate. Notice how I get a ruby array in the range call thereby
side-stepping 100 (slow) calls (it is faster, but only as a proportion
of a gigantic amount).

Its not enough 'though; the performance problem in 1.8.2 is of
elephantine proportions. Someone here also suggested, some time ago,
that WIN32OLE has 100% cpu usage even when idle?!? Was that a hoax (I
haven't tried testing for that)? That might go some way to explaining
my problems.

Anyone one else experiencing this, apart from the odd posts to this
group from the past?

Greg