I solve following problem. I have 10 000 users and every user send to database 30 data segments (one segment = 1 byte) per minute. I need also using search. I have no idea what database scheme is best to save this data. Can you help me please? I use MSSQL 2005 server.
Not always. Number of segments can be less or greater than 30 segments.
Segment is ONE byte - etc. 30 segments is packet whose size is 30B (I selected bad convention ... sorry ) Segment is simply one byte.
I am storing results of health measurement etc. ecg, heartbeat.