| Account Details | |
|---|---|
| SteamID64 | 76561197960497430 |
| SteamID3 | [U:1:231702] |
| SteamID32 | STEAM_0:0:115851 |
| Country | Netherlands |
| Signed Up | October 13, 2012 |
| Last Posted | March 21, 2026 at 12:27 AM |
| Posts | 755 (0.2 per day) |
| Game Settings | |
|---|---|
| In-game Sensitivity | |
| Windows Sensitivity | |
| Raw Input | |
DPI |
|
Resolution |
|
Refresh Rate |
|
| Hardware Peripherals | |
|---|---|
| Mouse | |
| Keyboard | |
| Mousepad | |
| Headphones | |
| Monitor | |
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.
AnAkkkReleased an update to fix the auto updater.
<3
If possible, retest with a wire, because those are some 90s speeds you're getting currently.
Explain why you think a different router will fix the described problem.
I could suggest some high speed OpenWRT router with proper SQM support, but if your internet line is shit, it won't help a bit.
Is your measured speed truly 8.5 megabytes down and 0.4 megabits up?
To get the best advice, please fully describe how you are connected to the internet. Starting at the wall, connection type, modem, router, switches, cables, powerline adapters, etc.
turbochad69ArieMade by Chris, of chrisconfig fame: https://github.com/cdown/mac-celThis probably won't work on recent osx versions since that IOHIDLib stuff was deprecated in 10.11 or 10.12 (4-ish years ago)
I've last used it in 10.13 when there were still proper nvidia drivers for OS/X
Made by Chris, of chrisconfig fame: https://github.com/cdown/mac-cel
AimIsADickThe mastercomfig documentation leaves out some tips like chaning DNS servers...
I'd hope so, cause he knows what he's talking about.
eu.voice.tf isn't the actual mumble server address I guess? Because that hostname currently resolves to 23.227.167.56 in Dallas and pings like you'd expect from EU.
If it is expected, I can provide you an actual EU server to use instead for this project.