Hi,
On PokerDIY my Create a League page (button on top right once logged in) has ground to a halt. It got slower and slower and now takes about 1 full minute to load the Edit League page. This is the same for normal users and the admin users. Strangely enough, logged in as Host account is instantaneous.
I ran profiler on it and it looks like it is running
exec dbo.GetFolderPermissionsByFolderPath @PortalID=6,@FolderPath=’Profiles/M/1353/’,@PermissionID=-1
for every single folder under the portal. The problem is the design I chose for the Smart-Thinker profile pictures - each userID gets their own folder, so now I have 40k of folders under the main "Profiles" subfolder.
It is the core File Upload control (URLControl) which is causing this - if you remove it then it loads instantly. The strange thing is that when logged in as a normal user you can only see about 5 folders (of which the biggest "Profiles" is not one.
Does anyone know any more about this? Is it not possible to just check the file perms on the top level folder and assume it cascades to all it's children (if it does NOT have permission). Any quick fix to get around this?