Increase Loading Speed and Reliability

[girish]

@firmansi I would try two things:

• Bump the memory limit of the app to say 2-3GB or so.
• Adjust apache prefork configuration as you see fit. It's in /app/data/apache which you can edit using the File manager. Specifically you can bump up MaxRequestWorkers to a higher number say 50 or so.

<IfModule mpm_prefork_module>
    # On startup, start these many servers
    StartServers    2

    # At any given time, keep atleast these many servers
    MinSpareServers 2

    # At any given time, keep atmost these many idle servers (this is always >= MinSpareServers+1)
    MaxSpareServers 3

    # Maximum number of servers at any given instant. Requests will be queued after this
    MaxRequestWorkers     15

    # Recycle process after handling these many requests. This protected against accidental memory leaks
    MaxConnectionsPerChild   100
</IfModule>

[humptydumpty]

The difference is day and night! I might have gone overboard with the values, but it's on my homeserver so it should handle it just fine.

<IfModule mpm_prefork_module>
    # On startup, start these many servers
	StartServers	10

    # At any given time, keep atleast these many servers
	MinSpareServers	10

    # At any given time, keep atmost these many idle servers (this is always >= MinSpareServers+1)
	MaxSpareServers 20

    # Maximum number of servers at any given instant. Requests will be queued after this
	MaxRequestWorkers	  95

    # Recycle process after handling these many requests. This protected against accidental memory leaks
	MaxConnectionsPerChild   200
</IfModule>

[firmansi]

Thanks @girish for the input, how about collabora office, is there any optimization needed? and also reddis cache, is there any tips on how to set the memory size to sizing with nextcloud usage?

[firmansi]

@humptydumpty what's your server spec for this configuration? will the spec have impact on apache configuration?

[humptydumpty]

I5-6500T and 8GB RAM. Idk about the impact on apache but the resource usage look the same in the graphs.

[girish]

@firmansi AFAIK, collabora office has no specific settings to optimize.

Turns out there are a bunch of settings. If you see https://github.com/CollaboraOnline/online/blob/master/coolwsd.xml.in , there is num_prespawn_children and also max_concurrency. Maybe you can play with those settings a bit. On Cloudron, this file is in /app/data/coolwsd.xml .

[firmansi]

@girish thanks...i will try to put this on play and see how things going

[firmansi]

After trying this and that, i finally uninstall collabora and deactivate nextcloud office, the loading time is not that good even after optimization, we stick to use nextcloud as storage and document management without office capabilities

[girish]

@firmansi have you tried onlyoffice as well? that one also has office integration.

[firmansi]

After trying Onlyoffice Docs for the the last 15 days, i can say onlyoffice is better than Collabora, it runs and loads faster than collabora with the same machine specification and number of users, now i turn back on the nextcloud office with onlyoffice ,i can say this solution is more reliable than collabora office which is slow and failing most of the time