• 0 Posts
  • 7 Comments
Joined 1 year ago
cake
Cake day: June 12th, 2023

help-circle

  • I was heavy into skateboarding as a kid, and I was interested in making some skateboarding media website with images and videos. I had initially began with wix, because I had no idea programming was a thing (I barely used technology, or even a phone). I messed around with it for a while, and then learned that I could make websites with just a simple html file… And the rest was history. Ended up getting into PHP, then game development with Java, etc.


  • Staying on the SQL theme… The company I work for has a fairly old (~20 years) system. There’s a feature for users and site admins to export massive amounts of data, with the option to export data from when the system was first released. Purely CSV or XML data formats. On large datasets, the time for export would vary from 10-20+ hours, and would frequently timeout, forcing you to split exports into multiple timeframes and manually merging them into a single file. The solution? Indexes! Indexes were non-existent. After adding them, export times have dropped to ~10-15 minutes, which is a rather insane performance increase, especially since a single export is accepted per account at a time.


  • Yeah, same here. I spend all day at a computer, last thing I want to do is spend more time at a computer. I’ve also spent more time working on my own vehicle’s, and just generally being outside more often.

    One thing that I do enjoy from time to time is graphics/game programming. Nothing really ever results from any of my projects, but it is something I enjoy, as i don’t do graphics programming at my job… It’s usually systems/web development, so the difference in the type of projects I choose to do as hobby programming has helped for me.