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
Wing server can't handle big audit file?!
-
- Site Admin
- Posts: 2107
- Joined: Tue Sep 29, 2009 6:09 am
Re: Wing server can't handle big audit file?!
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.
-
- Site Admin
- Posts: 2107
- Joined: Tue Sep 29, 2009 6:09 am
Re: Wing server can't handle big audit file?!
New version 4.3.5 has improved the speed of generating the audit report, you can upgrade to it.