How good of a processor do you need to have large excel files open quickly....

Discussion in 'Mayberry Lounge' started by rorydaboss, Dec 19, 2012.

  1. rorydaboss

    rorydaboss Brown Belt

    Joined:
    Jun 27, 2012
    Messages:
    3,889
    Likes Received:
    98
    Would something with the following specs be able to destroy large excel files:

    Processor 3.5 GHz FX-Series Six-Core FX-6120
    RAM 10 GB DDR3
     
  2. zere0wn

    zere0wn Green Belt

    Joined:
    Jun 9, 2007
    Messages:
    1,103
    Likes Received:
    0
    Location:
    U.S.A.
    What you doing in excel? Any modern computer will open any normal excel file relatively quickly.

    HOW big we talking?
     
  3. Tankeray

    Tankeray The Progeny of Beast of Woe

    Joined:
    Jul 8, 2012
    Messages:
    13,547
    Likes Received:
    1,362
    One that's over 9000 at least.
     
  4. rorydaboss

    rorydaboss Brown Belt

    Joined:
    Jun 27, 2012
    Messages:
    3,889
    Likes Received:
    98
    lol, I'm not really sure. My bro said they were big enough to slow down the computers at work, though I have no idea on the specs on those.
     
  5. DoctorGonzo

    DoctorGonzo Brown Belt

    Joined:
    Dec 18, 2011
    Messages:
    2,927
    Likes Received:
    9
    Location:
    Everybody knows this is nowhere
    6 cores @ 3.5GHz and 10GB of ram :eek:

    That thing will be an absolute beast, I assume it would do everything fast
     
  6. zere0wn

    zere0wn Green Belt

    Joined:
    Jun 9, 2007
    Messages:
    1,103
    Likes Received:
    0
    Location:
    U.S.A.
    I don't think you'd see a significantly noticeable difference between the computer you listed and anything more expensive that currently exists.
     
  7. 22k

    22k ベルセルク

    Joined:
    Feb 3, 2008
    Messages:
    27,219
    Likes Received:
    34,089
    Location:
    New York
    locally to your machine? also depends on the content the excel doc contains
     
  8. 22k

    22k ベルセルク

    Joined:
    Feb 3, 2008
    Messages:
    27,219
    Likes Received:
    34,089
    Location:
    New York
    yesh 6 cores means you're ahead of the game as it stands
     
  9. dza76wutang

    dza76wutang Black Belt

    Joined:
    Nov 24, 2008
    Messages:
    6,589
    Likes Received:
    134
    Location:
    Providence, Rhode Island
    After you get passed 50MB or so they can really run slowly. At around 200-400MB they straight die.

    Mind you if you are doing something that big you probably should be in SAS or SQL Server.

    Disclosure - I am referring to my work PC, my home rig may perform better.
     
  10. itooknarro2knee

    itooknarro2knee Blue Belt

    Joined:
    Mar 15, 2012
    Messages:
    780
    Likes Received:
    19
    when someone says their "computer at work" does anything slow... 9 out of 10
    times its all the shit their IT guys have running on it and all the shit they have managed
    to install with out telling their IT guys.
     
  11. Plissken

    Plissken Gold Belt

    Joined:
    Nov 28, 2005
    Messages:
    15,845
    Likes Received:
    3,064
    Location:
    New England.
    AMD's multi-core processors don't have hyper threading, so it'd be the equivalent to a 3 core 6 thread Intel processor.
     
  12. tsuifuku

    tsuifuku Black Belt

    Joined:
    Jun 11, 2008
    Messages:
    5,007
    Likes Received:
    1
    If an excel file gets so big that it's slowing down your computer it's probably time to learn Access.
     
  13. MajinSaga**

    MajinSaga** Banned Banned

    Joined:
    Aug 28, 2012
    Messages:
    2,955
    Likes Received:
    6
    Location:
    Лос-Анджелес, Калифорния
    Core i7 3770k, 16gb Corsair Platinum RAM, GTX 690 in SLI, Asus Maximus V formula, liquid cooling, OCZ Vertex 4 256gb SSD's in RAID 0, an 27" Apple Cinema display, and all housed in a Silerstone TJ11 case :cool:. That should do it.
     
  14. dza76wutang

    dza76wutang Black Belt

    Joined:
    Nov 24, 2008
    Messages:
    6,589
    Likes Received:
    134
    Location:
    Providence, Rhode Island
    And if you're even remotely considering Access you may as well use SQL Server, SAS, R, Minitab, etc.

    Access sucks hard.
     
  15. Youthanized

    Youthanized Guest

    Commodore 64.
     
  16. dza76wutang

    dza76wutang Black Belt

    Joined:
    Nov 24, 2008
    Messages:
    6,589
    Likes Received:
    134
    Location:
    Providence, Rhode Island
    Or they just moderately powered because the admin assistants and the quantitative analysts get the same models.
     
  17. 22k

    22k ベルセルク

    Joined:
    Feb 3, 2008
    Messages:
    27,219
    Likes Received:
    34,089
    Location:
    New York
    I would hold dual core processors to be the absolute bare minimum.


    & what's this I keep hearing about Atom processors? I've read somewhere that it's supposed to be reinvented. I call boolshit
     
  18. Brampton_Boy

    Brampton_Boy Douchey Mc Douche

    Joined:
    Dec 7, 2002
    Messages:
    6,821
    Likes Received:
    5,159
    Location:
    Brampton, Ontario
    Honestly, you would be much better served investing in a SSD than a processor (although the one you selected is fine. I personally prefer the i7 series with hyperthreading, but you will be paying about twice the price).

    I used to run macros on pretty large excel files (dumps from an MS Access Database that were often 200+ megabytes) without issue on a Core 2 Duo.
     
  19. 22k

    22k ベルセルク

    Joined:
    Feb 3, 2008
    Messages:
    27,219
    Likes Received:
    34,089
    Location:
    New York
    ^^ SSDs run a hell of a lot better with sata 3
     
  20. Gaylords Force

    Gaylords Force Blue Belt

    Joined:
    Dec 13, 2012
    Messages:
    765
    Likes Received:
    3
    Location:
    los angeles
    Intel is better than amd. Also get an ssd(solid state drive)
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.