At 06:03 PM 12/06/08, Marcin Bury wrote:
Chris
The answer is ONE table - perfomance is the matter of proper indexes...
I would recommend create compund primary key for this table - SENSOR_ID,
UNIQUE_COLUMN
Hi Marcin,
thanks for your response. The current primary key is timestamp,
sensor_id but sensorid, timestamp would work just as well and may
prove a little better I suspect.
Cheers,
Chris.
_______________________________________________
Delphi-DB mailing list
Delphi-DB@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
