It's not Ruby that's slow, it's your database

Re:It's not Ruby that's slow, it's your database by strken on Tuesday November 08, 2022 @08:14PM (#33526450)

I haven't used Rails or ActiveRecord for a long time, but from memory it gives you an escape hatch in the form of Arel that lets you represent parts of your query as SQL while still using the ORM for the rest.

Edit: I think it's something like

    Album
      .select(:id, :name, "SUM(songs.length) AS total_length")
      .left_outer_joins(:songs)
      .group(:id)
      .order("SUM(songs.length) ASC")

I think you don't even need to explicitly wrap it in Arel.

[ Parent | on HN ]

Re:It's not Ruby that's slow, it's your database by kayodelycaon on Tuesday November 08, 2022 @09:42PM (#33526980)

I use rails every day. Looks close enough. You’d just need to specify the fields with the table name, I.e. ‘albums.id’.

Also, for anyone reading, a total_length method dynamically will be added objects returned. :)

[ Parent | on HN ]