code_junkie

How many rows can an SQLite table hold before queries become time comsuming

Nov 11th, 2011
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. sensors
  2. - id (pk)
  3. - name
  4. - description
  5. - units
  6.  
  7. sensor_readings
  8. - id (pk)
  9. - sensor_id (fk to sensors)
  10. - value (actual sensor value stored here)
  11. - time (date/time the sensor sample was taken)
  12.  
  13. SELECT * FROM sensor_readings WHERE sensor_id = x AND time > y AND time < z
Add Comment
Please, Sign In to add comment