[Release] vSRO Removing Logs Better Server Performance

[denise456]

Effect
This Query Removes the database logs. but decreases the server lag and memory usage bringing more performance for the machine.

LogChar [Recommended] Removes the history of creation and the log of [Char]
LogItem [Recommended] Removes the history of change's and the drop's [Itens]
LogSchedule [Recommended only for home server] Removes the history log of account [1] in smc [GM]
LogServerEvent [Recommended] Removes the history of All [Event]
LogSiegeFortress [Recommended only for home server] Removes the history of FTW Hour beginning and Finish

Open your SQL > Execute in Log_DB

[Mirceagab]

I strongly recommend to keep the logs. But of course, if you have a cheap host you can remove them and it will indeed increase the performance a bit, especially if you have a populated server.

Another recommendation, buy a SSD hard-disk. It will make the difference.

[ღ ∂ Ropp]

^
And for what do you need the logs for?
Just keep the [GM] logs on seperate system.

[Kape7]

Originally Posted by ღ ∂ Ropp

^
And for what do you need the logs for?
Just keep the [GM] logs on seperate system.

Logs are really important for check scams and when a player reports a problem on his char or account. You can remove them if you don't give support to your players, but IMO its pretty useful.

[ღ ∂ Ropp]

Scams, I don't deal with scams.
If you were scammed, simply you failed hard @ not using a TA.
Problems with account, you just get all the information you need from the reporter.
^ That's my opinion, but hey, it's what I think.

[pH33n1x<3]

Remove every logs, except items logs. problem solved.

[xxnukertube]

******* Logs, i'm Have Server (5 Months) and No Have Logs Zuahahha
**** Scammers and no tell for scam action

[IceAmStiel]

I've got to recommend keeping them too, you could probably disable unnecessary ones from beeing logged - plus delete every log which is e.g. 3+ days old.
You can build up fancy things by only using the log feature, also you can rebuild their structure to increase performance anyway

btw to disable them a simple "RETURN;" after "as" is enough, it'll break the execution as well

[Black~EviL323]

Please give Credits if you leeched it from Jangan @ RZ..

[kubed]

nice