Answers to Chapter 18

  1. "Disabling as many extensions as possible increases the speed of your scripts: true or false" True, but not massively. Each extension has to do some work each time a request comes in, but it's very minimal.

  2. "Adding indexes to every field in your table maximises the chance of top performance: true or false" False: overindexing is almost as bad as not indexing at all!

  3. "What is the difference between a DELAYED query and a LOW_PRIORITY query" DELAYED queries are not executed immediately, but are queued up until a sufficient number of queries is ready or a certain amount of time has passed, then are executed at normal priority. LOW_PRIORITY queries wait until no more reads are waiting.

 

Next chapter: Answers to Chapter 19 >>

Previous chapter: Answers to Chapter 17

Jump to:

 

Home: Table of Contents

Follow us on Identi.ca or Twitter

Username:   Password:
Create Account | About TuxRadar