Right before I left Samsung Austin Semiconductor (Samsung’s fab in the U.S.), in 2019, they were phasing out local share drives in favor of a self-hosted cloud that Samsung created. The supposed reason was better security, though it’s unclear to me why they couldn’t globally apply whatever rules they wanted to enforce to all office locations, instead of forcing everyone to use a remote endpoint. The throughput was absolutely terrible, like < 1 MBps. My department had some large files, so that was fun.

One such file was an Excel file that was more script than anything else. We had to have labels in a specific format on every machine we owned in the fab, which was something like 250 of them. The normal stuff like its id number, and also which points of contact for a technician and engineer, as well as their photos and phone numbers. Manually balancing and re-balancing every time a shift gained or lost an employee would’ve been obnoxious, so naturally instead countless hours were spent coercing VBA and ODBC to query a DB containing employee info, extracting and resizing their headshot, applying all of this to a template label, queuing a print job, and repeating. It was pretty fun to watch, honestly. I think I also had created a floor plan map somehow, and it would do its best to group a given technician’s assigned machines such that they minimized distance traveled during inspections. Anyway, the large file size was due to it caching the headshots (might have made a hidden tab for each? I don’t remember) for better performance, as that had proven to be a bottleneck.