-1

As it is well known performance impact is quite significant when using the new SSD as opposed the old disk drives. If MySQL database including all the data is on SSD, how does that compare to NoSQL database on SSD such as MongoDB in terms of run time performance?

This will be used in application requiring hundreds if not thousands of queries and updates per second.

user61766
  • 103
  • 5
  • 1
    It depends. NoSQL isn't about performance. It's about being non-relational. – p.campbell Jun 13 '11 at 22:35
  • 1
    Bunch of questions here: 1) Are you comparing MySQL+SSD to NoSQL+HD, or to NoSQL+SSD? 2) What kind of queries / requests are you making of the database? 3) Why do you want to know (because that information will help drive the correct answer)? The answer may be: Try it and find out. – Slartibartfast Jun 14 '11 at 04:34
  • Ist it correct.....? - No. Apples and Oranges. In some cases it will be faster, in other slower. – symcbean Jun 14 '11 at 09:39

1 Answers1

2

I might be wrong on this as I'm far from a NoSQL expert but I believe the overhead of a traditional RDBMS is not entirely limited to disk i/o. NoSQL databases like MongoDB lack features like transactions which make MySQL more stable. Something like memcached might be a better way to go to speed up mysql performance while maintaining the reliability of an RDBMS

DrPppr242
  • 121
  • 1