Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #9738

Re: Excel automation and performance speed

Newsgroups comp.lang.clipper.visual-objects
Date 2016-09-15 11:46 -0700
References <5nh2tblrktqlvlos0k0jshol7m21a1vh4u@4ax.com> <af0e3568-726c-4578-8a7a-fbe8f26c14fd@googlegroups.com> <q2hjtb97fv8tpn37cg0jmo9o6jm5knngvc@4ax.com>
Message-ID <7bd3d958-e168-4fd5-bed6-445bbe25d4cb@googlegroups.com> (permalink)
Subject Re: Excel automation and performance speed
From dlzc <dlzc1@cox.net>

Show all headers | View raw


Dear D.J.W. van Kooten:

On Wednesday, September 14, 2016 at 2:45:31 PM UTC-7, D.J.W. van Kooten wrote:
> Replying on message of Tue, 13 Sep 2016 06:54:37 -0700 (PDT) from
...
> >Bitness:
> >http://stackoverflow.com/questions/37009284/excel-automation-slow-on-64-bit-server
> >... so maybe a 64-bit version of Excel on the server?

I ran a report from Quickbooks, to Excel 2016.  It took 4x as long under Windows 10 + Excel 2016 (quad core fast machine), as it did under Windows 7 + Excel 2010 (quad core AMD, 7 years old).  The Excel version and "bitness" might be abnormally important.

> I hoped that this was the cause. I couldn't find
> a proper About in their Office 2007 (I still hate
> the ribbons in Office) but a suggestion to just
> look in Task Management showed it was 32 bit.

... and I suspect that M$ has a "bug" to get people to avoid 32-bit software on 64-bit machines with 64-bit OSs, by taking inordinately long to do normal tasks.

> >Excel version:
> >http://dailydoseofexcel.com/archives/2015/04/07/excel-2013-vba-unreasonably-slow/
> >... what version got installed on the new server?
> >
> I'll go through this next!

Please report back what / if you find improves things, even if my suggestions were useless.  Posterity will thank you, and so will I.

David A. Smith

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Excel automation and performance speed D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-09-08 13:13 +0200
  Re: Excel automation and performance speed "Jamal" <noooospam@example.com> - 2016-09-08 15:19 -0400
    Re: Excel automation and performance speed D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-09-12 11:41 +0200
      Re: Excel automation and performance speed dlzc <dlzc1@cox.net> - 2016-09-12 08:44 -0700
      Re: Excel automation and performance speed "Jamal" <noooospam@example.com> - 2016-09-12 12:45 -0400
  Re: Excel automation and performance speed dlzc <dlzc1@cox.net> - 2016-09-13 06:54 -0700
    Re: Excel automation and performance speed D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-09-14 23:45 +0200
      Re: Excel automation and performance speed dlzc <dlzc1@cox.net> - 2016-09-15 11:46 -0700
        Re: Excel automation and performance speed D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-09-20 11:45 +0200
        Re: Excel automation and performance speed D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-10-25 00:02 +0200
  Re: Excel automation and performance speed Karl Wochele <kw@ecos-system.invalid> - 2016-09-16 07:46 +0200
    Re: Excel automation and performance speed "Jamal" <noooospam@example.com> - 2016-09-16 15:38 -0400
      Re: Excel automation and performance speed dlzc <dlzc1@cox.net> - 2016-09-16 13:44 -0700
        Re: Excel automation and performance speed "Jamal" <noooospam@example.com> - 2016-09-17 11:36 -0400
          Re: Excel automation and performance speed dlzc <dlzc1@cox.net> - 2016-09-17 11:14 -0700
            Re: Excel automation and performance speed "Jamal" <noooospam@example.com> - 2016-09-18 02:53 -0400
              Re: Excel automation and performance speed dlzc <dlzc1@cox.net> - 2016-09-18 13:05 -0700
          Re: Excel automation and performance speed dlzc <dlzc1@cox.net> - 2016-09-20 07:19 -0700
            Re: Excel automation and performance speed "Jamal" <noooospam@example.com> - 2016-09-20 15:21 -0400
              Re: Excel automation and performance speed dlzc <dlzc1@cox.net> - 2016-09-25 08:20 -0700

csiph-web