Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 37 of 37

Thread: Macs and DB engines

  1. #21
    it *is* a slow program.. tho seems slower on yours then mine.
    else.. don't know what to say. I'll tell the client to try the updated version and give me their specs.

  2. #22
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    It seems that the size of the file is the limiting factor. It's been 22 minutes and is only up to 850 rows on Excel 2004.

    I will try to limit the rows to about 2000 and see what happens.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  3. #23
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Also, I noticed that when I tried to Exit, if there were few files, the Exit worked as expected. But I finally pulled the plug on the Excel 2004 after 25 minutes, but the Exit button didn't stop it. After 4 times of trying to stop it, I had to Force Quit Excel.

    Now I am trying it with 2500 rows. In 8 minutes it has exported 350 rows. So a little faster.

    If you don't mind I might look at the code tomorrow night, just to take a gander at what is going on.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  4. #24
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    There must be something affecting the OS X version. Here are the results from 2500 rows of data, with seven columns selected:

    Excel 2001 (OS 9.2.2) - 15 minutes completed and properly formatted in Word 2001

    Excel 2004 (OS X 10.3.4) - at 35 minutes but only 44% complete

    Thus a version running on a platform whose processor is 4 times slower about 40% less RAM out performs the faster processor by a wide, wide margin.

    Now I am curious about the code itself. I don't have time tonight, but will examine it.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  5. #25
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Final results (both using 2500 rows - identical):

    Excel 2001 (OS 9.2.2) - 15 minutes completed and properly formatted in Word 2001

    Excel 2004 (OS X 10.3.4) - at 1 hour and 22 minutes properly formatted in Word 2004

    Thus a version running on a platform whose processor is 4 times slower about 40% less RAM out performs the faster processor by a wide, wide margin (5 times faster on the slower machine).

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  6. #26
    strange...
    hmm - I did think the client once mentioned it locking up.. but it's not really.... Now - is it Excel or the OS???

  7. #27
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    A Microsoft statement regarding ODBC drivers:

    <http://www.microsoft.com/mac/product...4/xl_ODBC.xml>

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  8. #28
    nope - bad link
    hhm - I thought I had posted another message.. specs from the client....

    Mac
    10.3.4

    Office

    X

    I edited the list down the the first four items on the list and hit
    'Export'. That was 19 minutes ago and I'm still waiting.

  9. #29
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Quote Originally Posted by starl
    nope - bad link
    hhm - I thought I had posted another message.. specs from the client....

    Mac
    10.3.4

    Office

    X
    You did - post # 15.

    I edited the list down the the first four items on the list and hit
    'Export'. That was 19 minutes ago and I'm still waiting.
    Something else must be going on. I know that with 20 items, it was done in less than 5 sec. Even on the older machine with 2001 it was still less than 10 sec.

    I had other projects in the fire over the weekend - mostly theology, so I'll look again tonight at this one.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  10. #30
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Quote Originally Posted by starl
    nope - bad link
    hhm - I thought I had posted another message.. specs from the client....

    Mac
    10.3.4

    Office

    X

    I edited the list down the the first four items on the list and hit
    'Export'. That was 19 minutes ago and I'm still waiting.
    Okay, I pared the list in Excel down to 1,000 rows with 7 columns of data. It took exactly 7 minutes to do it - this with OS X 10.3.4 and Excel 2004.

    Next I will try with 1,000 rows and 62 columns of data.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  11. #31
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Interesting: this time with 1,000 rows and selecting all 62 columns - 5 min. 42 sec. I assume that is because it doesn't have to filter any of the columns.

    One question - once the client begins the process do they then work on other tasks in other programs? (Safari, Entourage, etc.) The reason I ask is that changing programs in the midst of it might slow down the process considerably. In fact, the other night I used one small program, switching out of Word, and the time was excessively long.

    I will try the 25000 rows now with 62 columns. Then I will try it with activating other programs than Word to see what happens.

    BTW, each time I run this I use a new copy of the original sheet, so that they all are "starting from the same point".

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  12. #32
    but - the program works - just slow. ON this client, it ain't working at all!

  13. #33
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Okay, with 2,500 rows and 62 columns - it took 15 min. 58 sec. But of that time 1 min. 28 sec. was spent on the formatting at the end. (again OS X 10.3.4 and Excel 2004.)

    I'm beginning to think that if there is any attempt to switch programs - of any kind, even back and forth between Word and Excel it starts to slow down.

    With the client's computer, does the program freeze? Are they able to follow the percent window?

    Are they going to upgrade from Excel v.X to Excel 2004? That might make a difference.

    Sorry, I'm not more help on this.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  14. #34
    don't know. problem - my contact with the client having the problem is 3rd person.. *sigh* but - I'll take your latest resutls and run for now.
    hey - didn't you say that you read something about conflicts? cross-app?

  15. #35
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    One possibility here about conflicts:

    Did they have a Test Drive version of Excel v.X on the machine, and then just installed the registered version, without uninstalling the Test Drive version? In some cases that can cause problems.

    Special Bulletin: Before you install Microsoft Office v. X or the standalone versions (Microsoft Word X, Entourage X, Excel X, and PowerPoint X), you must first remove the Office v. X Test Drive from your computer. Please see Remove the Office v. X Test Drive before installing Office v. X or standalone versions of Word X, Entourage X, Excel X, and PowerPoint X.
    http://www.microsoft.com/mac/support.aspx?pid=bulletin

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  16. #36
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Here is a page that has some references for VBA programming in Excel v. X.

    http://support.microsoft.com/default...b;en-us;310330

    Also, I happened to notice a reference to MsgBox differences (basically the Help button does not show up in Excel v. X, but will in 97 and 2000). I wonder if there might be something connected with the MsgBox that is used that is causing a conflict.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  17. #37
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    This may be it?

    Running Macros

    Macros that make calls to custom 16-bit DLLs The DLL source code must be recompiled into a PowerPC version before the macros will run in Excel X.
    http://www.microsoft.com/mac/resourc...mats_Excel.xml

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •