Which db manager for a 100Go Table?

110
June 18, 2017, at 6:57 PM

I realize a 2G / 3G / 4G data retrieval project as part of my studies. I have to store this data, and to make queries on it. My table : [freq {float}, dbm {float}, timestamp {init}] I receive about 15GB per day of data, from 100000 to 200000 entries per minute, and that's for 6 day's.

I could use a simple DBMS (MySQL / Postgre) but I'm afraid that performance is not there. I tried with InfluxDB, but the number of lines recorded per minute is less than my needs.

Do you have another solution?

Thank's a lot, J-F

READ ALSO
how do you display a column value from a certain row in SQL?

how do you display a column value from a certain row in SQL?

Let's say i have a table named my_table and i have 2 columns

189
Port 3306 not listening? Can't connect to MySQL remotely

Port 3306 not listening? Can't connect to MySQL remotely

I'm trying to connect to MySQL remotely with pymysql and I'm getting the error message:

297
calculate a sum of type time using sql

calculate a sum of type time using sql

How to caculate sum of times of my colonne called "timeSpent" having this format: HH:mm in SQL? I am using MySQL

217
How can I retrieve zip file from MySQL blob in C#?

How can I retrieve zip file from MySQL blob in C#?

I have a problem during C# programming

279