Abstract
Reliability of data transfer rates between data acquisition equipment and an SQL database were tested using different data loads, server loads, test durations and data update intervals. The error rate was measured by the percentage of data changes missed by the transfer method. HTTP, FTP and web services data transfer methods were subjected to an initial evaluation with preliminary results but were not subjected to complete tests due to hardware limitations. OPC and SQL proxy methods were subjected to a broader range of tests using data loads of 20, 40 and 60 variables, server loads of one and three UIOs, test durations of one and eight hours and update intervals of 150 ms to 2500 ms. The OPC method resulted in better performance compared to the SQL proxy method with zero error data update intervals as low as 250 ms compared to 500 ms at the lightest loads or 400 ms compared to 2500+ ms at the highest loads. The results of this study provide initial data for selecting a data transfer method.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
