Hi guys, since long ago I have often been haunted by questions like this title, when I moved from blogspot (google hosted) to self-hosted (shared hosting), because my site often went down, at that time I didn't know whether this was caused by the hosting provider or because my site was not optimized.
It's true that I developed my website myself like my own child, built with love but minimal experience, I use CodeIgniter as the core framework.
At that time, when it was down, I immediately checked in cPanel and it turned out that my bandwidth consumption was still reasonable, but my processor rate consumption was quite high, maybe this was because I didn't use cache, or temporary memory, so every time a visitor visited my site they always executed a query, maybe that was what underlies my perception of the processor usage metric.
At that time, the only option that was in my head was to move to a VPS, but because I had already renewed the service, I was forced to wait, because it would be a shame (wasteful) if the hosting that had been rented was not used.
Okay, long story short, I was starting to get tired of being superman, juggling the roles of web and android developer, finally after pondering this for a long time, I finally decided to commit to focusing on becoming a specialist mobile developer and stop my adventure as a web dev.
I felt that the website I had built so far was not perfect, so I decided to use another platform to express my wild ideas and thoughts, and that choice fell on Flarum.
New experience
I felt quite a big difference when I had completely migrated all my content to this platform, still in the same hosting class, namely shared hosting, I felt extraordinary performance, fast whoosh whoosh... the CURD activities that I did felt very light.. but indeed there were some content data type transformations that I did, because previously all my images were put in the database as base64 and this not only takes up memory but also requires quite heavy processing to be presented to the client.
Long story short, I am getting more curious about the question in this title, it is very ticklish because the new platform that I am using really breaks my perception so far, finally I googled and found a quite interesting review, namely one of the stackoverflow members who told his experience that he had used shared hosting on reliablesite.com, there he mentioned that he had reached 10-20K users, and 100-200K pageviews, this proves that shared hosting is actually quite good.. but I wonder why it is not like what I experienced? even though the class used is also the same as shared hosting... it turns out the answer is here, guys..
He gave a disclaimer that all of that is relative to the technology used on the related site, the more queries consumed then it can impact the site's performance. He gave an example of a site that uses ASP.NET MVC, the technology is certain to need processor optimization (compute engine), emphasizing that ideally ASP.NET is running on VPS, if forced on shared hosting it is not certain to reach 200K pageviews.
Conclusion
- How to optimize a website greatly influences web performance.
- One of the website optimizations is minimizing requests to the database.