I'm self-hosting an instance of Invoiceninja on Ubuntu 16.04 using Nginx and mysql
I currently only have about 1400 clients, 1700 invoices and 13k products. however loading invoices takes roughly 5-15 seconds per invoice. This doesn't seem like a lot of data to be slowing down so much.
I've added query caching in mysql but that has not alleviated any performance issues.
I've also tried to identify what exactly is holding up the load times using chrome's dev tools but I can't decipher what's causing the loading issues.
I tried posting this to the invoiceninja forums but for some reason I'm unable to create a new post.
Where should I be looking in order to identify what is holding up loading invoices?
This problem is most likely related to the amount of products. Please use the new v5 which works hopefully more performant. Currently v5 is in alpha state, the official release is roughly in one month.
Check the Github account or the forum how to get the v5 up and running.