I was just asked by the database administrator at one of my clients if Servoy has a way to automatically rename or overwrite the .service_log.txt file when it gets too big… Periodically we have to manually rename it and start a new one to speed up our system. Our most complicated report (which feeds in from stored procs in MS SQL Server) was taking 40 seconds before we renamed this file and now is back to a max of 10 seconds (on the biggest dataset, much less on some).
It’s not the restart of the service that solved it, btw – we auto restart the machine every night at midnight.
For the windows service wrapper we use external library from: http://wrapper.tanukisoftware.org
You can have the log file roll, switch to different files, set max file size
see for example:
http://wrapper.tanukisoftware.org/doc/e … gfile.html
these settings can be set in service/wrapper.conf file
If the log files becomes so huge, are you not having the servoy log level just to low?
in your servoy.properties by default is:
log4j.logger.com.servoy.j2db.util.Debug=WARN
is this there for you as well?
I really wonder why do you restart your server each night?
how many memory does your server have?
ever checked the used memory on admin page?