[Lob (UK]

Originally Posted by bobis I tried to delete the TF2_Stats.smx plugin and replace it with playerranks.smx but my server still has lag spikes. Same lags with 1.6 stable and 1.7 dev: Plugins used:

Yes i have had to remove my Stats plugin since using 1.6 versions. TF2_Stats and Player Ranks both cause slow down on the Server once a few players are on. It may have something to do with Sqlite but not sure yet and still haven't found a fix for it as of yet.

- Lob

[Aderic]

Originally Posted by Lob (UK Yes i have had to remove my Stats plugin since using 1.6 versions. TF2_Stats and Player Ranks both cause slow down on the Server once a few players are on. It may have something to do with Sqlite but not sure yet and still haven't found a fix for it as of yet. - Lob

I am the person who made Player Ranks; though I can't for the life of me figure out why it would be causing any slowdown for you. All queries are threaded, which means the server should not be delayed and forced to wait on anything.

I run it on my own server so maybe we can find something in common..

My server is Linux
SourceMod 1.6.2-dev+4562
Metamod:Source version 1.10.3-dev

[The Unusual Gold]

I've gotta ask this question but it seems like my start parameters doesn't work, any help?

Happened when the 9/10/2014 update was released.

[Sreaper]

Originally Posted by The Unusual Gold Ive Gotta Ask Do Anyone Of You Know Why My Paramenters Aren't Working. They Stopped Working With This 9/10/2014 Update :/ (Im Danish So If I Spelled Something Wrong You Know Why)

What parameters? Also do not Speak In All Caps Like This. Only the first word of a sentence and the letter I by itself is capitalized.

[The Unusual Gold]

Originally Posted by Sreaper What parameters? Also do not Speak In All Caps Like This. Only the first word of a sentence and the letter I by itself is capitalized.

C:\TF2Server\tf2\srcds.exe -game tf +sv pure 0 +mapcyclefile Mapcycle.txt +map koth_lakeside_event +login anonymous

That is what i use to start my server but the +map and +sv pure doesn't work.

But also my SteamIDs is messed up again because of this update so do i just need to wait for a SourceMod and MetaMod update?

[Lob (UK]

Originally Posted by Aderic I am the person who made Player Ranks; though I can't for the life of me figure out why it would be causing any slowdown for you. All queries are threaded, which means the server should not be delayed and forced to wait on anything. I run it on my own server so maybe we can find something in common.. My server is Linux SourceMod 1.6.2-dev+4562 Metamod:Source version 1.10.3-dev

Important to remember that it is not just your Stats plugin that does it, it is all Stats plugins that do it. The slow down problem never existed in versions prior to 1.6. Never had any slow down for at least 5 years before updating to 1.6 versions and above. I had tested the 1.6 official version when it was first released and had to remove it due to this slow down with stats plugins problem. I went back to 1.5 snaphots at the time but then after the Steam ID change update, i had no choice but to use 1.6 versions and after trying out quite a few stats plugins, had no choice but to just remove them and have no Stats on the Server at all as all Stats plugins caused major intermittent slow down and made the Server unusable.

Server is Windows and and is currently using SourceMod 1.6.2-dev+4562 and Metamod:Source version 1.10.3-dev but like i say, all 1.6 versions have had the slow down even before the steam id change update.

- Lob (UK)

[Aderic]

Originally Posted by Lob (UK Important to remember that it is not just your Stats plugin that does it, it is all Stats plugins that do it. - Lob (UK)

I understand what you're saying, but I don't understand why.

What do all stat plugins have in common? Probably MySQL (or SQLite in your case).

Unless the issue is in SQLite itself on SM...

Hmmmmmm. I don't use SQLite, if this was the case then it would make sense why I'm not getting them.

I might have to do some testing on a local server to determine the issue.

[friagram]

Originally Posted by Aderic I am the person who made Player Ranks; though I can't for the life of me figure out why it would be causing any slowdown for you. All queries are threaded, which means the server should not be delayed and forced to wait on anything. I run it on my own server so maybe we can find something in common.. My server is Linux SourceMod 1.6.2-dev+4562 Metamod:Source version 1.10.3-dev

How often do you query?
Some of those stats plugins are awful and query every callback, when they should only be doing so on player connect/disconnect.

2queries is better than 2000+queries per player, especially if you are doing that crap in a loop.

[Aderic]

Originally Posted by friagram How often do you query? Some of those stats plugins are awful and query every callback, when they should only be doing so on player connect/disconnect. 2queries is better than 2000+queries per player, especially if you are doing that crap in a loop.

On client connect a query is done to get their score, and an additional query is done to get their rank.

Every update interval it cycles through each connected client, saves their score and fetches their new rank and finally grabs the top 25 users.

On client disconnect a query is done to save their score.

It's all threaded and pretty well optimized.
The update interval can be adjusted, but it runs every 30 seconds by default.

I used to use a stat plugin that saved on every action; teleport.. kill.. death.. It never lagged me either.

I have tested PR extensively to ensure it runs properly with SQLite, but my public server does not run SQLite. If this is something introduced with later builds of SM then I think it may be out of my hands.

[Lob (UK]

Originally Posted by Aderic I have tested PR extensively to ensure it runs properly with SQLite, but my public server does not run SQLite. If this is something introduced with later builds of SM then I think it may be out of my hands.

It is definitely something that has only happened in later builds i.e 1.6. I was using the same Stats plugin for 5 years and never had any slowdown problems at all. It only started happening from 1.6 onwards. I dont think it is anything to do with the plugins. It is something that has been changed in 1.6 onwards and is possibly to do with Sqlite.

- Lob (UK)