I am trying to make a server database.
Lets say I have a database with 2 million records. Each record has 22 columns and all the information inside the database is numeric. Only numbers.
The database is 300mb. I have 20 thousand records per table.
I heard that you can load databases on memory.
I put this database on a server. If I load it on the memory how many transactions can I have per second? Will the hard drive still play an important role? And what role will the processor play? Lets say I want the database to handle 1 000 read / write per second?
What hard drive do I need? VelociRaptor?
Can PostgreSQL handle it or will I need MySQL?