Explore BrainMass

Explore BrainMass

    Importance of having enough RAM

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    What is the importance of having enough RAM? How does it relate to how fast a computer can process data from a large database residing on ones hard drive? What is the importance of virtual memory if you don't have too much RAM & how does it relate to query speeds?

    © BrainMass Inc. brainmass.com March 4, 2021, 7:58 pm ad1c9bdddf
    https://brainmass.com/computer-science/memory/importance-of-having-enough-ram-135088

    Solution Preview

    Swapping takes up system resources. The time to access the hard disk is hundreds of times slower (se below) than the time to access RAM. Therefore, if speed is an important consideration, you should think about having enough RAM so you don't swap.

    - Ideally all database keys should fit in RAM, however watch total memory usage, swapping kills the performance.
    - As database table size increases, number of seeks increases. If tables get really big or if you don't have enough RAM, bound by disk seek speeds.
    - If you have enough RAM, the Operating System caches the physical (database) files as they are used therefore improving the ...

    Solution Summary

    The importance of having enough RAM is explained. How does it relate to how fast a computer can process data from a large database residing on ones hard drive is explored. What is the importance of virtual memory if you don't have too much RAM & how does it relate to query speeds are explained.

    $2.49

    ADVERTISEMENT