SoftwareIntrospectionLab/MininGit — pull request #158 by linzhp (2012-04-28 00:21:30+00:00)
Title: FileTypes speedup

FileTypes was insanely slow on repositories with decent size. The reasons are:

* It gets the list of files from `action_files` joining `files`. The former is a view based on a complex `select` ruling out file changes with type 'R' but not file copies.
* Related tables are not properly indexed.

As it seems that getting the list of files from `action_files` is not necessary, I get it from `files` table instead. Indices are added to related tables as well. This speeds up the execution of that SQL from a few days to a few seconds on Eclipse JDT repository.