LabVIEW
How much faster is Citadel database than SQL Server 2005 and why?
Citadel is specifically optimized for historical data logging. For this it uses a very specific internal data format. It is not meant and can't really be used for generic database storage as it consists really of one table per channel with only three rows each being the actual timestamp, status and value.
@coolrentals wrote:How much faster is Citadel database than SQL Server 2005 and why?Are there any bench mark examples?When would one want to use SQL Server 2005 instead of Citadel?Thank you!
General purpose databases allow you to setup your own tables in just about any form you can think of and also allow to define relationships between those tables.
So your question about using SQL Server versus Citadel is not really very useful. If you have to store historical data that is organized in channels with individual timestamps for each value and have Citadel available you use that. Otherwise you use your prefered SQL server.
While you can log historical data to a generic SQL server you can not log arbitrary data to Citadel, but I would guess on comparable hardware Citadel beats any SQL database implementation in speed and database size when you need to log historical data from acquired channels.
Rolf Kalbermatter
