[Owncloud] very slow Shared folder access

[Michael Gapczynski]

This is due to file cache rescans when you are entering the Shared folder. 
It's looking for new shared files. This performance problem will be resolved 
in ownCloud 5 thanks to changes in sharing.


Michael

On Wednesday, August 15, 2012 12:28:39 PM Trey Nolen wrote:
> I'm running OC 4.0.6 and have several users sharing files.  On some of
> the users, everything is OK, but I have a few that have VERY slow access
> to their Shared folder.  When you click on the Shared folder, it takes
> about 2 minutes to access.  As long as you stay inside the Shared
> folder, everything is OK - you can go into subfolders quickly.  However,
> if you ever leave the Shared folder and try to go back in, the clock
> starts again on the slow access.
> 
> The platform is Ubuntu 12.04 running Apache and MySQL.
> Running "mytop" while waiting to access the Shared folder shows very few
> queries runnning.  THe processor usage on Apache and MySQL are very high
> while waiting, though.
> 
> This is one of the queries running:
> Query SELECT source FROM oc_sharing WHERE target =
> '/User.Name/files/Shared/NDW/Project Managment' AND uid_shared_with
> IN('User.Name', 'User.Name at All Users', 'User.Name at SEA Associate',
> 'public') LIMIT 1
> 
> It seems to be doing one of those for each folder.
> 
> This machine has plenty of I/O.  I have the server set to log slow
> queries (slower than 1 second) and it is not logging anything during
> this process.
> 
> Any ideas on why this would only affect some users and/or what I can do
> to help it?
> 
> 
> Trey Nolen
> 
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud