Wing server can't handle big audit file?!

Here you can submit your bug reports.

Wing server can't handle big audit file?!

Postby Andreas WP » Tue Nov 19, 2013 10:15 am

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
Andreas WP
 
posts 4
 
joined Tue Oct 22, 2013 12:57 pm

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

Postby FTP » Tue Nov 19, 2013 2:00 pm

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.
FTP
Site Admin
 
posts 1220
 
joined Tue Sep 29, 2009 6:09 am

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

Postby FTP » Sat Jan 11, 2014 7:44 am

New version 4.3.5 has improved the speed of generating the audit report, you can upgrade to it.
FTP
Site Admin
 
posts 1220
 
joined Tue Sep 29, 2009 6:09 am


Return to Bug Reports

Who is online

Users browsing this forum: No registered users and 1 guest