kipusoep/UrlTracker — pull request #7 by jclementson (2014-03-19 08:31:59+00:00)
Title: Add an index to the database.

The database is seriously in need of an index to preserve website performance, especially once there are thousands of 404 entries. This pull request contains the index recommended by Database Engine Tuning Advisor for the query that is made for every page request. When we applied this, our SQL server CPU load dropped from 80% to 5%, and web page response times dropped from 500ms to 20ms! It may be possible to define a better index that is also optimised for storage space as well as performance, but I have not done that yet.