Arie
Account Details
SteamID64 76561197960497430
SteamID3 [U:1:231702]
SteamID32 STEAM_0:0:115851
Country Netherlands
Signed Up October 13, 2012
Last Posted July 18, 2021 at 10:38 AM
Posts 590 (0.2 per day)
Game Settings
In-game Sensitivity
Windows Sensitivity
Raw Input  
DPI
 
Resolution
 
Refresh Rate
 
Hardware Peripherals
Mouse  
Keyboard  
Mousepad  
Headphones  
Monitor  
1 2 3 4 ⋅⋅ 40
#448 Formula 1 Megathread in Off Topic
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.

posted 1 week ago
#16 trends.tf - TF2 stats collected from logs.tf in Projects

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.

posted 1 week ago
#14 trends.tf - TF2 stats collected from logs.tf in Projects
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.

posted 1 week ago
#4 Help getting player name from steamID3 in Q/A Help

Steam condenser has ruby, java and PHP implementation to do this.

https://github.com/koraktor/steam-condenser

posted 4 weeks ago
#4 cant find villa demos from last night in Q/A Help

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.

posted 1 month ago
#6 A TF2 crash that I haven't seen/heard before… in Q/A Help

https://www.teamfortress.tv/59525/cant-join-any-servers-max-players-1

That thread has like 1/3 of the words and the solution.

posted 2 months ago
#4 what's the best tf2 server provider atm? in Q/A Help
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.

posted 2 months ago
#204 TFTrue in Projects
AnAkkkReleased an update to fix the auto updater.

<3

posted 2 months ago
#3 unplayable ping spikes in Q/A Help

Try with a wire first.

posted 2 months ago
#5 good internet router in Hardware

If possible, retest with a wire, because those are some 90s speeds you're getting currently.

posted 2 months ago
#3 good internet router in Hardware

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.

posted 2 months ago
#9 Is there a way to disable Macbook mouse accel? in Hardware
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

posted 2 months ago
#5 Is there a way to disable Macbook mouse accel? in Hardware

Made by Chris, of chrisconfig fame: https://github.com/cdown/mac-cel

posted 2 months ago
#10 Proper Performance Guide on TF2. [UNFINISHED] in Customization
AimIsADickThe mastercomfig documentation leaves out some tips like chaning DNS servers...

I'd hope so, cause he knows what he's talking about.

posted 3 months ago
#16 voice.tf - free mumble channels in Projects

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.

posted 3 months ago
1 2 3 4 ⋅⋅ 40