Page 1 of 1

Wing server can't handle big audit file?!

Posted: Tue Nov 19, 2013 10:15 am
by Andreas WP
Hello.
I have been running my wing 4.2.8 server for 5 weeks (on linux). I am not able to do an weekly/monthly report any longer. Got an server reject after ~9min.
The "Audit & Report" meny says it have 93400 pages. Each page have 100 lines. Aprox. 9.4M entrys in the audit_db file? audit_db size is 1.2GB.
When trying to generate a report nobody can connect to the web user interface. The ftp connections allmost stops and gets time out.
I have set the server to 4 threads.

/Andreas

Re: Wing server can't handle big audit file?!

Posted: Tue Nov 19, 2013 2:00 pm
by FTP
OK, "audit_db" is sqlite database file, if when you have 9.4M entrys, the SQLite performance will be slow, I suggest you copy the file "audit_db" into another computer for data analysis.

Re: Wing server can't handle big audit file?!

Posted: Sat Jan 11, 2014 7:44 am
by FTP
New version 4.3.5 has improved the speed of generating the audit report, you can upgrade to it.