Rails

Benchmarks: acts-as-taggable-on vs PostgreSQL Arrays

While looking at performance optimizations for a rails project, I noticed these lines in my debug console: ActsAsTaggableOn::Tag Load (0.5ms) SELECT “tags”.* FROM “tags” INNER JOIN “taggings” ON “tags”.”id” = “taggings”.”tag_id” WHERE “taggings”.”taggable_id” = $1 AND “taggings”.”taggable_type” = $2 AND (taggings.context = (‘tags’)) [[“taggable_id”, 103], [“taggable_type”, “Prediction”]] This makes sense,