Purchase Solution

Importance of having enough RAM

Not what you're looking for?

Ask Custom Question

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?

Purchase this Solution

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.

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

Purchase this Solution


Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Javscript Basics

Quiz on basics of javascript programming language.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.