I know that question has been asked before, but I didn't find anything about my pattern. I have got a DB that has about 10.000.000 lines. Every time program calls the DB, it reads (scans) it all and never writes anything. So what DB will be preferred for really big amount of lines, reading it every time and don't writing in?

CodePudding user response：

For your case you might want to check out a NoSQL solution. SQL vs NoSQL is a whole discussion, but afaik the TL;DR version is:

• SQL databases are more flexible for adhoc combining/aggregating/filtering records in several related tables, but performance slowly drops with more and more data, i.e. they don't scale.
• NoSQL works better when you want to read/write huge amounts of records (millions or more) of one single objecttype without relations to other records/objects in that same database.