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 Brown Belt

    Joined:
    Jun 27, 2012
    Messages:
    3,890
    Likes Received:
    2
    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 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 Primordial Covenant

    Joined:
    Jul 8, 2012
    Messages:
    14,604
    Likes Received:
    793
    One that's over 9000 at least.
     
  4. rorydaboss Brown Belt

    Joined:
    Jun 27, 2012
    Messages:
    3,890
    Likes Received:
    2
    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 Brown Belt

    Joined:
    Dec 18, 2011
    Messages:
    2,929
    Likes Received:
    0
    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 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. weed ʇɹǝdxƎ nʞᴉɐH

    Joined:
    Feb 3, 2008
    Messages:
    39,769
    Likes Received:
    18,821
    Location:
    ʞɹo⅄ ʍǝN
    locally to your machine? also depends on the content the excel doc contains
     
  8. weed ʇɹǝdxƎ nʞᴉɐH

    Joined:
    Feb 3, 2008
    Messages:
    39,769
    Likes Received:
    18,821
    Location:
    ʞɹo⅄ ʍǝN
    yesh 6 cores means you're ahead of the game as it stands
     
  9. dza76wutang Black Belt

    Joined:
    Nov 24, 2008
    Messages:
    6,591
    Likes Received:
    0
    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 Blue Belt

    Joined:
    Mar 15, 2012
    Messages:
    783
    Likes Received:
    0
    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 Gold Belt

    Joined:
    Nov 28, 2005
    Messages:
    18,507
    Likes Received:
    1,782
    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 Black Belt

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

    Joined:
    Aug 28, 2012
    Messages:
    2,951
    Likes Received:
    0
    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 Black Belt

    Joined:
    Nov 24, 2008
    Messages:
    6,591
    Likes Received:
    0
    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. Commodore 64.
     
  16. dza76wutang Black Belt

    Joined:
    Nov 24, 2008
    Messages:
    6,591
    Likes Received:
    0
    Location:
    Providence, Rhode Island
    Or they just moderately powered because the admin assistants and the quantitative analysts get the same models.
     
  17. weed ʇɹǝdxƎ nʞᴉɐH

    Joined:
    Feb 3, 2008
    Messages:
    39,769
    Likes Received:
    18,821
    Location:
    ʞɹo⅄ ʍǝN
    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 Douchey Mc Douche

    Joined:
    Dec 7, 2002
    Messages:
    8,785
    Likes Received:
    3,589
    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. weed ʇɹǝdxƎ nʞᴉɐH

    Joined:
    Feb 3, 2008
    Messages:
    39,769
    Likes Received:
    18,821
    Location:
    ʞɹo⅄ ʍǝN
    ^^ SSDs run a hell of a lot better with sata 3
     
  20. Gaylords Force Blue Belt

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

Share This Page

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