Hi All, i am not sure if this is the right forum, but i couldnt find a SQL section.
I am writing an application to log data from our PLC system to a SQL database. I would like to write a record every second. I have it all working fine, but i am worried about the potential to "overload" on data and cause the system to become unsable.
Is there anything specific i should be doing on the table in the SQL server to accomedate the ammount of data?
I may be changing to minuite logging, but just wanted to check