[Owncloud] very slow Shared folder access

[Trey Nolen]

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