I have made an application that uses an MS SQL database table_measured_values (600 sensors, each sensor up to 50.000 samples) for extracting data, then i make a lot of calculations in php and then store the data in MS SQL database table_month_results.
To keep this process alive i ping from one to another webpage on my web server.
The problem with this "solution" is:
1) it's takes about 4 hours till the proces is done.
2) but worse, i sometimes miss 2 or 3 sensors and then these sensors have to be found and done manual..
Are there any suggestions for continuing on the php path are should i start learning about stored procedures on MS SQL server 2005/8?
There is 1 reply in this thread, which is not being displayed. Browsing this forum thread replies is available only to premium subscribers.
Go to the premium subscriptions page to learn how to become a premium subscriber and have full access to this forum.