Linked Questions

0
votes
1answer
132 views

What is the maximum number of columns allowed on a table in MySQL MEMORY storage engine? [duplicate]

The official MySQL documentation the the MEMORY storage engine covers maximum table size (in MB) but the maximum number of columns that can be defined on a table is not specified. This question is ...
34
votes
2answers
24k views

Timeseries: SQL or NoSQL?

I don't care about the general differences between SQL and NoSQL (or their traditional differences). I am currently looking at altering the storage of our internal time series. They all contain ...
13
votes
2answers
4k views

Database redesign opportunity: What table design to use for this sensor data collection?

Background I have a network of approximately 2000 sensors, each of which has about 100 data points that we collect on 10 minute intervals. These data points are typically int values, but some are ...
3
votes
2answers
7k views

More than 20 columns in database table MySQL

I have an object, that is described by 40 properties, is it good a idea to create a table with 40 columns? I think that I cannot break these properties into another table (such as table_properties_1 ...
6
votes
2answers
19k views

MySQL: Row size too large (> 8126)

I have a table which has 300 columns in it. Each column is up to 255 bytes (there is a business justification for this). When I try it create it using VARCHAR(255), I go past the limit for the ...
0
votes
2answers
5k views

mysql - query records to fetch by time stamp

I've a MySql 5.6 DB with a simple table (MyISAM) . | UniqueKey | TimeStamp | ------------------------- | 1 | 1024125412 | | 2 | 1024125413 | | 3 | 1024125414 | My table will ...
1
vote
1answer
1k views

Table with more than 100 columns

I have a table in my MySQL database which contains data about XRF analyses. There are about 50 chemical elements and for each element there are two values to be stored (Area and Count). Users need ...
2
votes
2answers
213 views

Is it ok to have 40+ columns in a table

I am currently re-designing some of DB's for a project. There is one DB in particular that is giving me a little of a headache. The idea is that for every client_id and date (client_id + date would be ...
0
votes
2answers
78 views

mysql database, 2400 records for 1500 rows

I need to create a new database, recording data for around 1500 sensors. I need to store hourly data, and keep a rolling database for the past 100 days. My first thought was to create a database ...
1
vote
1answer
87 views

Designing a database structure for huge sets of form data [closed]

I am converting a form that takes up 35 pages of A4 size to a web based version, and will need to retain the data for each form submission in a MySQL database. The form is complex and we could be ...