these are my specs below. i would say the hardware is fast enough. php has 1024MB of memory now.
what if i try to create a ram disk and put my sql there? would that work?
The server runs on a HP Z200 workstation with an intel Xeon X3470 3GHz 4 core processor, 8GBs DDR3 RAM and 3 x 250 GB Seagate HDD ST3250312CS.
I am the only user on my Nextcloud and I usually don’t perform any heavy tasks. On average, the CPU shows 1% usage and RAM about 1.5 GB. I also have 250 GB of free hard disk space available.
i updated my nextcloud to 19.0. i was told on the overview page that i’m using an old version of PHP. indeed 17.2 was 4 years old. so i updated php to 7.4. i also updated mysql to 8.0 and apache to 2.4 and i already could see a vast improvement.
i tuned php. i set script memory limit to -1 (i disabled it) and i setup opcache memory consumption to 4GB. i found out that i had to edit the php.ini file in the apache2 folder of php, not the cli.
i also noticed that nextcloud is just much faster on chrome / chromium / vivaldi. i always use firefox to browser, but it seems that in this case there is a big difference in speed.
now the server is very fast. i’ll be checking it out for a few more days, but i think it should work.
funny that i solved my own problem, but at least other people who will have the same issue can just use this thread to figure it out.
AFTER A FEW DAYS
there is still a slight lag when i come back to nextcloud after a few hours for the first time, but it’s definitely much much better. and the next page loads are very fast. so i think all the settings above did help out.
just note that i am the only user on my server, and the server is dedicated to nextcloud. so depending on your situation, my solution might not work.
For me was upgrading from 23.0.10.1 to 24.0.6.1
this mean because of upgrading the system or disabled apps (not compatible)
the situation
was none admin users when access the system was very slowwwwww
when check console reach more than million request (maybe as verbose)
well Done 
