Comments on How to Install Polr Link Shortener on Debian 10

I don't know the experience of other people with Polr, but at least for me it has been disastrous. I installed Polr in production last year, like 14 months ago, and everything seemed to be OK, just was doing its job, shorten URLs. However, since a month my Polr DB has passed the million shortened links, and everything went down. It uses Eloquent as ORM, and queries made with it are zero optimized, I have had to change some Eloquent instructions to raw queries, and created a couple of indexes, however it's still causing problems, NewRelic detected several thousands of queries to DB when the site is receiving less than 10 requests per minute, something ilogical, and that causes PHP eating all the server RAM. I'm really disappointed of this software, I'm still trying to keep it on going in production, but I've decided to develop my own shortener using Spring Boot..