Good morning everyone…
I am new to ths Nextcloud and i just finished my first few steps and got itrunning.
Still some issues, but if i cant fix them i will be back 
So…now my machine is adding songs to the Music app (roughly 23000) and it is brain numbing slow…
Thats why i wondered what the root course might be.
Hardware or db software.
My system is an old Netgear Pro 6 with these specs:
Operating System: Linux 6.1.0-26-amd64 x86_64
CPU: Pentium(R) Dual-Core CPU E6700 @ 3.20GHz (2 threads)
Memory: 3.82 GB
And a raid 6 with 6 3 TB drives
But i also run SQL lite and was wondering if the speed was due to limits on the db or the hardware or both…
Thx for any hint
SQLite slows down your setup for sure. It’s one of the first (check out the first section here: Using the occ command — Nextcloud latest Administration Manual latest documentation).
Use the caching servers on top of that, further improves the speed.
If then, you still see it is too slow, and it is mainly the CPU usage (no RAM shortage or i/o limitation), then I’d consider a change of the CPU.
1 Like
Apart from what has already been said about chaching and SQlite, I would really recommend retiring your E6700 and switching to something more modern.
Your CPU only has two cores, and a passmark score of only 1182 with a TDP of 65 watts. Intel Pentium E6700 Benchmark
In comparison, a current low-end N100 CPU has 4 cores and a passmark score of 5512 with a TDP of only 6 watts! That’s five times the performance at a tenth of the power consumption. Intel N100 Benchmark
A modern midrange 65 watt CPU such as the i5-12400f even has a score of 19528, i.e. 16 times the performance with roughly the same power consumption! Intel Core i5-12400F Benchmark
Not to mention the fact that modern platforms have significantly faster interfaces and support NVMe SSDs, which are many times faster than SATA SSDs or conventional hard drives.
Thx alot for the answers.
Changine the cpu is unfortunately not possible on that mainboard. Its the oeiginal board of the nas and i already went for the fastest possible on it.
New cpu would mean abandoning the nas since the housing is not meant to take a regular micro atx.
I tried to install everuthing with maria db but the install alone was a nightmare due to tons of errors and “cant find db”,“cant create admin account” and so on. After i fjnally had it running it ran worse than with sql lite.
Real bummer.
Have to think and make decisions.
Thx guys
That wouldn’t help much anyway, because it’s the whole platform that’s slow and out of date.
Any N100 Mini PC, or literally any modern PC, will outperform even mid-range server platforms from 15 years ago, or at least deliver similar performance with far less power consumption. But your NAS is based on a mid-range PC platform from back then. 
It’s not just the CPU, but also RAM, storage, etc. Literally everything is massively slower than in even a low-end modern system.
In Germany i think you must pay for 65 watts 24/7 almost 130 euro a year. 6 watts only 12 euro a year. For 24/7 you pay every year 100 euro extra.
1 Like
Yes, although to be fair, the effective power consumption of an N100 system will probably be more like 10-15 watts with some moderate load on the CPU, an NVMe SSD and let’s say 16 gigs of ram, which of course is still consiberably less than what just the CPU uses in the old system, and if we assume that there are at least two spinning disks running in that old NAS, then those disks alone will probably consume almost as much power as the whole N100 system would
@Darkyputz Of course, you might still want to have a NAS with spinning disks for backups or maybe even the Nextcloud data folder, but even if you only use it for that, it might be worth switching to a current platform/model, as you would probably save a massive amount of power.
If power consumption is not an issue, you could keep the old NAS, but either way, at least the OS that runs Nextcloud itself with the database etc. should be installed on a more modern platform, and preferably on an SSD.
Nas os is on ssd since the nas itself has only 128 mb solid state drive with the netgear os on it, so i boot from usb.
I have 6 drives and they are my movie, music, photos, private data, nvr saving grounds and for testing right now nextcloud in docker
Looked at n100 boards and the work to do to make it fit…looks like i am better off by8ng a ready to use machine with full root rights.
One of the reasons i moved to the us from germany, cause energy is dirt cheap here with 11 cents per kw.
Using about 20-30 kwh a day which would ruin me financially in germany