Join for free and connect with our local tech scene

Stay on top of the latest companies and upcoming events with our weekly newsletter, and be counted among the people building the future of your local tech community.

Boston, MA /

The Secret Life of SQL: How to optimize database performance

Bryana Knight, an engineer on the platform-data team at GitHub, will present "The Secret Life of SQL: How to optimize database performance".

There are a lot of "best practices" in creating database indexes and queries that sometimes aren't "best practices" at all. Need all the users created this year? No problem! Slap an index over created_at and use a simple SELECT with a WHERE and you're all set! Now just active users? We'll just stick status on the end of that index and add an AND to that query! What about active OR pending users since January 1st, sorted by username? Are we still covered index-wise? Is our query even using that index? Is it as fast with twenty million users?

Database indexing and query crafting is more of an art than a science. There are a lot of rules of thumb we often follow that work the majority of the time, but not always. We'll discuss how to track down those exceptional cases and walk through real examples of when they work and when they don't. You'll leave so well equipped to optimize performance, you won't be able to get back to your app fast enough!

Bryana Knight is an engineer on the platform-data team at GitHub. Previously at WellMatch, Bryana has lots of experience writing Ruby, SQL, Ember and pair programming. She has lived in five different cities in the past eight years and enjoys traveling for work and for fun.

------------- Logistics -------------

MIT's map with the building (E51) highlighted: http://whereis.mit.edu/map-jpg?selection=E5...

MIT's map with the Kendall square T stop highlighted: http://whereis.mit.edu/map-jpg?selection=L5... (the stop is in red on that map, and you can see E51 in the bottom right)

MIT's maps with parking lot information: http://whereis.mit.edu/map-jpg?selection=P4... and http://whereis.mit.edu/map-jpg?selection=P5...

Note that MIT lots are free to park in after 3 pm or so, even if it says "reserved for faculty"

Free pizza and soda will be served, so please RSVP accurately.

To RSVP anonymously, please login to the Meetup site with the e-mail address "admin at sheeri dot com" and the password "guest". For more information, see: http://www.meetup.com/mysqlbos/calendar/

Comments

Sign in to comment.