Visualizing Rails logs With Jupyter Notebook

By Derek Bullet_white Comments Comments


Your Rails app appears to be humming along just fine. But then, out of the blue, one of your most important customers emails your support team: "the site is loading slowly - is something up"?

You frantically browse around the site, but everything seems fine. You double-check the charts: things look normal. Is the customer trying to trick you? Is monitoring broken?

In this post, I'll show how to slice-and-dice your Rails application log to uncover performance issues on the edges. With your new super powers, you'll be able to find that needle in the haystack.

Read More →


ActiveRecord: biting the hand that feeds you

By Derek Bullet_white Comments Comments

Richard Schneeman (better known as Schneems) recently wrote about how he reduced his database server load by 80%...with one simple trick. In the Hacker News discussion that followed, much of the debate was on the merits of using an ORM like ActiveRecord...or not:


In every case I can think of, writing raw SQL is likely to execute queries faster than using ActiveRecord. So, why don't I just write raw conn.exec('SELECT * FROM users') everywhere?

Read More →


Finding fast (but expensive) database queries

By Derek Bullet_white Comments Comments

A database is a shared resource for a Rails application. A single misbehaving query hitting your database can slow down unrelated queries throughout your system.

When we began running our own database monitoring against our apps, we discovered several expensive queries that weren't apparent when viewing individual web endpoints and backgrounds jobs.

Read More →


Autocorrect with Postgres Trigrams

By Greg Bullet_white Comments Comments

Rails Postgres Guru Greg Navis shares another powerful tip. Greg is writing The Ultimate Guide to Deploying Rails on Heroku. Subscribe to his mailing list for performance tips & tricks.

In my previous article on Postgres Trigrams, we used pg_trgm to speed up LIKE and other operators (even on phrases that aren't left-anchored). Today, we'll use the same module to implement auto-correction in a search engine.

Read More →


We're sharing our roadmap

By Derek Bullet_white Comments Comments

Years ago when we started Scout, we were vague on our roadmap. We recognized priorites and plans can shift and we didn't want that shifty-ness exposed.

However, things have changed by 2017. All of us have a general understanding of this behavior: we see it everyday in the GitHub repos we depend on and contribute to.

So, we're starting an experiment @ Scout: we're going to share ideas for our roadmap and the discussions behind them in a public repo. You're welcome to contribute issues and commentary.

You can find the repo here.


5 hard-earned lessons from a decade of Rails performance work

By Derek Bullet_white Comments Comments

The last 3,650 days of my professional life have been focused on making Rails apps faster. Below are five lessons I've learned the hard way.

Read More →


Older posts: 1 ... 5 6 7 8 9 ... 68