Week 21: Projects, Indicies and Concurrency

This is the second and final week working on our OtterZone medical database application. I've learned quite a bit about how querying remote databases works since we decided to host our DB on AWS to make changes and make our lives a little easier. The more frustrating aspect of this week has been the data validating side of this project, where I've been spending too much time thinking about different solutions to our problems.

Now to answer the prompt question of what is it meant by slow index:

A slow index is often blamed on a broken or unbalanced tree, a myth, as we know from our reading. Causes for slow queries when your tables are index can be caused by generally having an index cover too many rows, duplicate/similar rows, or too many table access operations are being performed.