[Release] vSRO Removing Logs Better Server Performance

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

[Only registered and activated users can see links. Click Here To Register...]

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.

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

Quote:

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.

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.

Remove every logs, except items logs. problem solved.

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

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

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

nice