All threads / Improving Query Performance with Database Indexes Discussion

Ask A Question

Notifications

You’re not receiving notifications from this thread.

Improving Query Performance with Database Indexes Discussion

This was awesome! Thanks Chris!

Reply

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

Reply
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: http://sorentwo.com/2013/12...

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

Reply
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!

Reply

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

Reply
Join the discussion

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

Join 37,106+ 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.

    Ruby on Rails tutorials, guides, and screencasts for web developers learning Ruby, Rails, Javascript, Turbolinks, Stimulus.js, Vue.js, and more. Icons by Icons8

    © 2020 GoRails, LLC. All rights reserved.