PHP Classes

Creating a month report

Recommend this page to a friend!

      Top level forums  >  PHP Specialists  >  General  >  Creating a month report  
Subject:Creating a month report
Summary:Php or something else for creating a month report
Author:J. Brussee
Date:2013-01-16 20:59:15
Update:2013-01-24 13:12:43

  1. Creating a month report   Reply   Report abuse  
J. Brussee - 2013-01-16 22:26:51
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.