title: How to model a table to save many metrics for same timestamp in QuestDb?
body: <p>I have zillion lot of sensors which tick every min with some floating point data and I want to use to save the data in QuestDb. I see two options:</p>
  <p>Options 1 is to create a wide table with zillion of columns and have one row per each minute</p>
  <pre><code>| Time  | Sensor1 | Sensor2 | .... | Sensor1232123 |
  | 10:01 |     3.4 |     0.0 | .... |          23.4 |
  | 10:02 |    5.46 |  23.987 | .... |           0.0 |
  ...
  </code></pre>
  <p>And the option option 2</p>
  <pre><code>| Time  |     Id |  Value |
  | 10:01 |      1 |    3.4 |
  | 10:01 |      2 |    0.0 |
  ...
  | 10:01 | 123123 |   23.4 |
  | 10:02 |      1 |   5.46 | 
  | 10:02 |      2 | 23.987 |
  ... 
  | 10:02 |      3 |    0.0 |
  ...
  </code></pre>
  <p>Since my data comes from individual sensors independently I'm inclined to use option 2 but the QuestDb requires the designated timestamp column to be ascending, so I cannot have duplicated values in <code>Time</code> column.</p>
  <p>It sounds pretty common case but I cannot figure out how can I store my sensors data in one table.</p>