I am being a terrible database person and duplicating data all over the place because these queries are taking way too long.

Who cares if I can have the date for all of these entries in a single place, storage is cheap and I am impatient.

Follow

@zatnosk my old CS professor always said that if you had the same piece of data in two places in your database you were doing something wrong.

But I guess strange is a lot cheaper now than it used to be.

@inmysocks eh, it's better to duplicate/cache a rarely updated number in a often read table, than join on a table with 100000 rows.
At least, that's my opinion. But whatevs, I'm a PHP dev, so I'm going for whatever works and not correctness or beauty.

Sign in to participate in the conversation
Awoo Space

Awoo.space is a Mastodon instance where members can rely on a team of moderators to help resolve conflict, and limits federation with other instances using a specific access list to minimize abuse.

While mature content is allowed here, we strongly believe in being able to choose to engage with content on your own terms, so please make sure to put mature and potentially sensitive content behind the CW feature with enough description that people know what it's about.

Before signing up, please read our community guidelines. While it's a very broad swath of topics it covers, please do your best! We believe that as long as you're putting forth genuine effort to limit harm you might cause – even if you haven't read the document – you'll be okay!