Issue Summary

Issue is reproducible: Yes

Steps to Reproduce

1. Create a Perforce repository
2. Create the directory structure as follows: ROOT > dir1 > dir2
3. Create 2500 files under dir2
4. Add the repository to Fecru and sync it
5. Create a review, add content, and navigate to Explore directories
6. Click on dir2. Notice that it takes 25s to load
7. Now add 2500 more files to dir2 and sync it again to Fecru
8. Go back again to the review, navigate to Explore directories, and click on dir2. Notice that it takes 1.7mins to load.

Expected Results

The directory tree should take less than a minute to load.

It was found that Fecru is doing one query on the cru_stored_path table for each file in the three.

Actual Results

The directory tree takes more than a minute to load. In some cases, the directory tree never gets loaded at all.

Fecru should be more efficient in running queries on the cru_stored_path table

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available