| Account Details | |
|---|---|
| SteamID64 | 76561197960497430 |
| SteamID3 | [U:1:231702] |
| SteamID32 | STEAM_0:0:115851 |
| Country | Netherlands |
| Signed Up | October 13, 2012 |
| Last Posted | October 3, 2026 at 1:33 PM |
| Posts | 762 (0.1 per day) |
| Game Settings | |
|---|---|
| In-game Sensitivity | |
| Windows Sensitivity | |
| Raw Input | |
DPI |
|
Resolution |
|
Refresh Rate |
|
| Hardware Peripherals | |
|---|---|
| Mouse | |
| Keyboard | |
| Mousepad | |
| Headphones | |
| Monitor | |
_flac(as any one persons poor connection can effect everyone elses experience)
I think this is a common misconception, the high ping of one (or even most) other players won't affect your experience by itself. John Carmack got it mostly right back in 1996.
The "teleporting timmy" example is way more annoying for other players, but a ping limit doesn't fix that.
The rule shouldn't exist at all.
hpqoeuif you're running a linux server just crontab it instead of something external. windows has something similar where you can schedule services
A linux-based TF2 server started with -autoupdate will auto-restart if you send a kill signal. So the simplest thing to make the above suggestion work is to add a crontab entry that runs:
killall srcds_linuxmaneI'm not surprised. From what I heard, tf2 logs are fist being locally saved in your server directory and then uploaded to logs.tf, right? Is the log file like in the root 'tf' folder or where should I find it?
In
tf/logsS4mskiLMFAO
Valterri it's James please abort
Fuck you I'm taking this fastest lap
He backed out in S3 :( Sadly, couldn't do it despite being cut from the team
justjazzand if so where can i donate for them to get better servers
I think most or even all of the demos are stored on Hetzner servers in Germany. Some ISPs love to fight with them over bandwidth and refuse to set up peerings, causing slow speeds for that ISP's customers.
taviChampionship battle about to get more intense now isnt it. I dont think you can blame either of them for the collision though
I think you can blame the driver that was behind, on the dirty side of the track, missing the apex, understeering into his opponent.
Hehe, those are some cool queries, I was hoping you were just missing some indexes or something, but it looks like you got all that covered.
An on-the-fly aggregation like the peers is always going to be challenging, especially since you're trying to find the top 100 players most played with/against.
One thing I would consider, is to move "log_wlt" and "player_last" from views to materialized views (unlike a view these need their own indexes). You could update these materialized views (concurrently) after a new batch of log files is imported. This might improve part of the peers query.
Forty-BotA little update:
I'm migrating the database from SQLite to PostgreSQL. I started this last week, and did the switchover this past weekend. However, some of the queries are now taking way longer than they used to. I am currently working on this. Availability might be a bit spotty until I can get to the bottom of things. I am also trying to get log importing back up, but that is going much slower than before too. Please be patient for the next few days :)
In the longer term, performance was and is a big problem with the site, even before switching databases. I would love if some more experienced developers could look over my schema/queries and help out.
I'll take a look if you share some slow queries (use postgres' slow query logger) and the entire DDL (pg_dump --schema-only) and put it in a github gist.
Steam condenser has ruby, java and PHP implementation to do this.
Demos.tf was unchecked for that reservation on na.serveme.tf
I've checked the zip for the reservation you played in, there are 4 maps played on villa in it, follow det-'s advice to find the link to the zip file.
https://www.teamfortress.tv/59525/cant-join-any-servers-max-players-1
That thread has like 1/3 of the words and the solution.
det-Personally, I rented mine through nfoservers and I'd say I'm happy with it. It seems to get ~5-10 ping less than serveme servers in the same location
Our Dallas and Chicago servers marked with (Anti-DDoS) are at NFOservers, so those should ping identically to something you rent yourself. In both Dallas and Chicago we also have non-NFO servers, which might ping better or worse depending on routing.
tony, since you're from Mexico, I suggest trying NFOservers in Dallas. You can try one for free at https://na.serveme.tf (they're called serveme.tf NFO Dallas #1-8 (Anti-DDoS)), that way you know what kind of ping to expect if you rent one yourself at NFOservers.