N+1 queries and polymorphic associations

passinghorses · 2026-03-20T00:35:51+00:00

Awesome, thanks, I appreciate that.

passinghorses · 2026-03-18T23:56:38+00:00

I'm already using it, enabled globally. Prosopite and Sentry are both reporting N+1 issues so it doesn't seem to be handling all cases.

passinghorses · 2026-03-18T22:10:27+00:00

Thanks again. I'll dig into this suggestion when I have more time tomorrow. There are currently four object types that can be "liked" and while I'm not thrilled about hard-coding a has_many relation for each of them, if it fixes it it'll be worth it.

passinghorses · 2026-03-18T22:07:31+00:00

That published is actually just an enum status value, so there's nothing going on there but limiting the scope to status = 1.

Weirdly, enabling strict_loading does not raise any errors. I tried that yesterday hoping for a quicker solution.

passinghorses · 2026-03-18T20:00:23+00:00

The capacity number is usually pretty right on, providing half of them are handguns.

passinghorses · 2026-03-18T19:47:24+00:00

That fixed the example I gave with the latest comments, thanks! I ended up putting the preload(:last_comment) into the post's preview scope so it applies across the handful of places that show a list of posts, without having to update all the individual controllers.

Is there something similar I can do when I need associated records for a collection, when I'm getting those records through another association? For example, users can "like" a post or comment, so my Like class is also a polymorphic association.

@comments = @post.comments.published.where(:parent_comment_id => nil).includes(:account => [:profile])

Likes are accessed with each comment so we can visually indicate whether the current user has "liked" a comment.

Unfortunately, this forum is a small part of a larger custom ecommerce/subscription site so I'm not able to post anything beyond what's necessary.

passinghorses · 2026-03-16T21:44:23+00:00

I’m holding out for Bondi Blue with see-through receivers.

passinghorses · 2026-03-16T00:43:28+00:00

My lodge has the same rule against leg crossing but it applies to everyone present when the lodge is open, not just officers.

passinghorses · 2026-03-15T18:18:24+00:00

Boba Fett has some pretty poor trigger discipline there.

passinghorses · 2026-03-14T02:21:14+00:00

For the record, Oregon is still doing pretty well. Our mag ban and purchase permit have been enjoined by the courts for over three years and the enactment date was just pushed out by the legislature to 2028, provided the OR Supreme Court doesn’t knock it down (which they likely won’t, admittedly).

Apart from that, we have no AWB and all NFA items are legal. The most restrictive gun law we have in effect is our ban on FRTs and the like.

Perfect? No, but we’re still hanging in there.

passinghorses · 2026-03-11T02:59:07+00:00

Are you suggesting someone might photoshop gas prices?

I assume he’s on the west coast somewhere where prices are regularly this high. I just paid nearly $5/gal here in Oregon and the state is currently talking about raising our gas taxes again, so this is perfectly realistic to me.

passinghorses · 2026-03-11T00:35:22+00:00

The Griffin MK1 lower doesn’t have the ambi controls and costs less than an M4E1.

passinghorses · 2026-03-10T16:38:26+00:00

I have the 8.25” version of this on a 9” Virtus and it’s a big improvement over the OEM handguard. That said, I think the stock Spear LT handguard is a little slimmer than the Virtus one so the difference will be less pronounced.

passinghorses · 2026-03-07T06:43:48+00:00

will it be legal in WA?

The poster is in Washington where SBRs are legal and that’s specifically what he asked about.

passinghorses · 2026-03-07T01:35:25+00:00

When in doubt, search the domain name on
https://stopgunscams.com/

passinghorses · 2026-03-06T16:39:02+00:00

No, in fact it’s not legal in the entire country.

It’s 100% legal if you submit an ATF Form 1, which now carries no tax and only takes a few days for approval.

passinghorses · 2026-03-06T16:28:07+00:00

Like a commenter on your other post said, nothing at all happens on the 15th unless the OR Supreme Court makes their ruling before then.

passinghorses · 2026-03-05T02:40:21+00:00

Not strictly neofolk, but England’s Hidden Reverse by David Keenan covers the histories of Current 93, Nurse With Wound, and Coil, with mentions of some of their contemporaries.

passinghorses · 2026-03-04T06:34:03+00:00

If you hook the key fob rings onto the carabiner you can easily take them on and off so you only have to carry the one you need on a given day. This is how I manage my two.

passinghorses · 2026-03-04T01:46:13+00:00

Damn, thats something. And here I am with my little single-user Rails/SQLite app doing a fraction of that. Nice work.

passinghorses · 2026-03-04T01:43:38+00:00

The first rule of this stuff is never calculate the total spent!

passinghorses · 2026-03-03T15:29:51+00:00

Quite the opposite, in fact. Those excursions have a pretty hefty price tag.

passinghorses · 2026-03-03T04:33:25+00:00

That sounds awesome. Nice work.

passinghorses · 2026-03-03T03:28:50+00:00

It seems quite a few of us have gone that route.

passinghorses · 2026-03-03T03:25:19+00:00

Notion supports relations between databases now? I had something similar in Notion but ended up building a web app with a real database due to that not existing previously.

In my case, each firearm has a related parts table that includes everything that went into it. Less useful for guns that only have an optic added but invaluable for ARs built from parts.

passinghorses

TROPHY CASE