Have all the data in one table would definitely be my recommendation... I would say that creating tables when adding sensors would be more hassle than it is worth (even if it happens very rarely/just at setup).
Regards Colin On 11/06/2008, at 6:29 PM, Chris Stebbing wrote: > Hi All, > > I have a question on database design if I may. The application that > I will be working on is an industrial one where we will be logging > data from a number of different sensors all at differing rates. The > "current" data value is used to initiate actions and is always held > in memory, but past data is most commonly graphed regularly. By far > the largest amount of data is generated by logging these sensors, > and the most common use for this data is simply graphing. > > An installation could range anywhere from 5 sensors to 100 sensors. > > The main question I have is whether it would be better to have all > these sensors log into one table, or have them log into a separate > table per sensor. The amount of data can build up quite an amount > over time, and filtering one large table (or querying one large > table) takes an amount of time. Having the data already separated > by sensor would be a huge head start. > > Thanks for any comments and my apologies if this question is out of > line here. > > Regards, > Chris. > > _______________________________________________ > Delphi-DB mailing list > Delphi-DB@elists.org > http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db ##################################################################################### Attention: The information in this email and in any attachments is confidential. If you are not the intended recipient then please do not distribute, copy or use this information. Please notify us immediately by return email and then delete the message from your computer. Any views or opinions presented are solely those of the author. #################################################################################### _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
