All threads / Improving Query Performance with Database Indexes Discussion
Ask A Question


You’re not receiving notifications from this thread.

Improving Query Performance with Database Indexes Discussion

It's too Awessome!!!!!!!!! Thanks Chris

James Shepherd ·

Hey Chris, this is exactly the sort of thing I would love to see more of. There are so many resources out there for building a rails app in development but very few resources like this to give us tips on production. Keep them coming! Thanks

Absolutely! Any other specific topics you'd like me to cover?

James Shepherd ·

Do you have any resources on when and how you insert pure SQL statements versus using active record? I was talking with someone about that the other day and it seems like an interesting topic that might fit in well with this video topic.

Oh really good topic! I usually try to avoid it as much as I can, but there's always uses for it because you'll never be able to fully express SQL with an ORM.

I was just reading this post on doing trending posts in Postgres and it was one of those great places where you'd want to drop down to raw SQL to create those functions and things that you could reference later with ActiveRecord:

I'll have to definitely do a screencast on this.

Keith Gapol ·

What do you guys think about the lol_dba?
I found it got all the basic relations I needed and then I built on top of. My apps production performance is crazy fast now!

Great episode. I never knew you can add an array for columns into an index!

Join the discussion

Want to stay up-to-date with Ruby on Rails?

Join 68,326+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    logo Created with Sketch.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

    © 2022 GoRails, LLC. All rights reserved.