Perfomance: Add index for url_path

[Alexnortung]

Feature request

Summary

I think the url_path field needs a database index, such that finding a url alias by it's path will be faster.

Suggested solution(s)

Take a look at the strapi repo code (or here) for an example.

[boazpoolman]

Is this feature documented somewhere?

[Alexnortung]

I guess it is an experimental feature, I don't think it is documented anywhere other than on their feedback page. I have noticed it multiple times when looking around in some of the strapi source code.

[boazpoolman]

Interesting. Are you currently having performance issues without the index?

[Alexnortung]

I have had some performance issues while building static pages for our frontend when we have 100s of pages, but I am not sure whether adding an index to url alias would be noticable anyway. My guess is that it could have some impact, since I use /webtools/router for each page.