I improved the PHP scripts which unpack the report files to the MySQL database. They unpack it to multiple tables now and they also update only records where the report data has changed. That should help to reduce problems with huge report databases.
All you need to do is:
- delete the existing reports table from the MySQL database on your web server
- unzip and copy the attached scripts to the /online_scripts folder on your computer, replacing the original script files index.php and unpackreports.php
- Have fun!
On the first run it will create the tables and import all reports. On all following runs it will only update records where the report content changed.
Obviously there will always be changes on each report page because there's a timestamp at the bottom of each page. To get rid of the timestamp, remove the [%VERSION] token from the page_bottom_line.tpl template (you'll find the template files inside the folder /templates).
Please give us some feedback here. Thanks!