Best way to store historical data

[Robst]

Hello:

I'm currently developing an application that monitors some phisycal variables such as temperature and differential pressure in different locations. I also must do historical datalogging of the values read so the user can generate reports of the historical data. What is the best way to save the data? I was thinking about using and SQL-based database and use a table for each variable, an make some maintenance on the database after certain time to avoid it getting too big, but I'm opened to any suggestions

Thanks in advance!

Robst

[cs42]

Just my usual reply to this kind of question: use the DSC Tag Engine (or it's LV 8 equivalent). IMO this is the most easiest way to store historical data if you're using LV!

Cheers,
    Carsten

[unclebump]

Use the Citadel database inside the DSC engine. It automatically handles file sizes when they get too large.

[Robst]

Hello:

Thanks for the advice... but I'm afraid we do not own DSC. I know DSC is a great option, but for this proyect it is not an option. In this situation, Which is the best way to store historical data?

Regards

Robst

[unclebump]

There might be an option to install just Citadel and use another method to get data into the database.

[Robst]

Hello:

I've been looking for a way to install just Citadel with no success. I've read that it only ships with Lookout and DSC, so I guess it can't be installed without one of them. Si, if this is true, Do U know another option for doing datalogging?

Thanks in advance

Robst.