Best PC for calculating huge data?
Results 1 to 2 of 2

Thread: Best PC for calculating huge data?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2018
    Posts
    85
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Best PC for calculating huge data?

    Hey Dear community,

    I use VBA to calculate very big files, with my pc ( 6gb ram ) it takes 35 - 40 minutes for calculation.

    I wanna know what if i make same calculation with server? ( 125gbram etc ) will there be very big difference in calculation time? or is there calculation time limit?

    What parametres are most important? CPU? RAM? RAID? SSD? is there difference between operation system?

  2. #2
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,141
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Best PC for calculating huge data?

    Hello

    I assume these are Excel files, and suggest the biggest difference in calculation time will be the way the calculations are done. The set up of the Excel file.

    There are old threads here where, IIRC, in one example array formulas took 6 hours and instead a query table approach took a second or two.

    So, suggest you initially optimise the way the calculations are done. If further improvements are required look at the computer, and even the software - MS Access for example might be more suitable than Excel.

    regards, Fazza
    To receive a better answer, put more work into asking the question.


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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