Hello Aaron,
Thanks for responding. The code for the PHP7 web app along with the
complexity of the database queries like a four table join can be seen
here: https://github.com/titomarifrancis/dap-dbms. I hope you forgive
the simplicity of my code, I tried to use a framework but given the time
and my objective to have a modest server specification for the target
machine that should won't have heavy traffic, I also wrote the code as
lightweight as possible.
I was planning to use OpenBSD exclusively for this project, looking
forward for a long running, secure deployment. Maybe next time I will
write web app using https://learnbchs.org but I really prefer PostgreSQL.
Hope the info I provided can help define the server specification(s) for
the project I'm working on. Thanks.
On 15/08/2019 11:21 AM, Aaron Mason wrote:
Hi Tito
Can you tell us more about the database? How often will its data be
changed, added to, etc? How much data do you have? How complex are
your DB queries? These answers will help determine the RAM and
processor requirements for the database.
As for the web server daemon itself, I think Reyk Floeter would be the
best placed to answer that question - also paging Nick Holland for
more hardware expertise.
On Thu, Aug 15, 2019 at 12:57 PM Tito Mari Francis Escano
<titomarifran...@gmail.com> wrote:
Hi to everyone at misc,
I'm recently working on an OpenBSD-based PHP7 web application with
PostgreSQL-backend for a local government agency and was wondering what
would you recommend as the acceptable server specification. This web
application won't reach the Google or Facebook level of visits per day,
but I was hoping to prepare this be deployed and run for quite a long
time and ready for about 60,000 visits per day at most.
Your advise and recommendation would be greatly appreciated. Thanks so much.
