Find your slow and common SQL

- [Instructor] One of your most common performance domains…you'll need to deal with, is your database code,…but if you use a modern framework,…many frameworks hide the raw SQL…behind an object relational mapping…and database abstractional layers,…so it can be hard to find your slow SQL queries.…However, we're going to walk through a few techniques…to help you out.…The simplest way is to figure out which pages…in your application are the slowest.…Refer back to our Xdebug section…on figuring out both how to record and time your slow pages.…

After you turn on your Xdebug logging,…you can than use this to then determine…how much time you're spending talking to your database.…All of the most common database engines,…include ways of logging your SQL queries…with a feature called query logging.…In MySQL, you can turn on query logging…by editing your configuration file…and adding it to set the general log to one or true,…and then set a path to log the output to.…In Postgres, logging is also a pretty much a setup…of just choosing a destination,…