CODEWITHSUNDEEP
sqldatabasenosql
mohammad
mohammad

Reputation: 57

Nosql or sql database for big temp data

I'm new to the data world.

I want to store a temporary data in a database. The volume might be 10000 rows per transaction. Data will be removed in less than 1 hour (based on creationTime). There wont be any complex queries and there might be 1000 or more transaction per minute.

For this need, which database type would be useful?

Upvotes: 1

Views: 201

Answers (1)

moritz.vieli
moritz.vieli

Reputation: 1807

It depends on the data structure and the use cases, not on the volume. If the data follows always the same structure, I‘d go for SQL. If the data sets are not easy to structure (e.g. have many different fields but only a few filled most of the time), NoSQL seems to be the better match.

There are databases for both types, which are able to handle large amounts of data.

Upvotes: 2

Related Questions