Can (should ) SQL be used for trend data in IFix

[BillyB]

Hi,
We are upgrading from fix32 to Ifix. We will be using SQL Server to hold and retrieve our alarm and Event data.

1.Can we also use SQL to hold and display Tag data like temperatures and pressures.

2. Will I be able to display this info(trend data) in a trend object on one of the graphics.

I know IHistorian is ideal for this but thats not currently in the budget.

Thanks
BillyB

 

[Mammoth]

Yes, you can!
Concerning Historian, ask your local office for a promotion kit. Currently, in Europe you'll get a 100pt Historian when buying iFix 5.0 f.o.c.

 

[Marshy]

You could use an SQT block to insert data into you SQL DB at set intervals?

 

[BillyB]

I could have 30 transmitters being collected every second for up to 4 days(Cycle lasts 4 days)
Which would equal 10,368000 entries. Is this too much???


I would also have the same for 2 other systems but would probably use seperate tables.

 

[surferb]

Should be fine - that's a great application for SQL Server. Ensure that any columns that you sort or filter by are indexed (especially timestamp).

I could have 30 transmitters being collected every second for up to 4 days(Cycle lasts 4 days)
Which would equal 10,368000 entries. Is this too much???


I would also have the same for 2 other systems but would probably use seperate tables.

 

[Mammoth]

With that amount of data, think about using Historian as a DB. With the built in compression the DB size is much less than with SQL. As I mentioned above, Historian comes with iFix f.o.c. (100pts). You can call the GEF office in Towcester (UK) if you're located in IRE for more information.