Activity log for bug #1465281

Date Who What changed Old value New value Message
2015-06-15 13:36:00 Mike Kelly bug added bug
2015-06-15 13:48:21 Mike Kelly description When working in groups where many files have been uploaded to the group space (hundreds or more), any part of the interface which uses the file browser slows significantly. For example when viewing the Files tab in the group, or when adding an Image content block to a group page. There are two aspects to this - the retrieval of the page from the server, and the rendering of the page in the browser. Both become significantly slower as more files are uploaded. Browser end In the Files tab in a group with about 250 files, the Mochiscript javascript starts throwing errors due to long processing time, when rendering the page in the browser. (Firefox 38). This appears to be due to the code which initializes drag and drop on files and folders. (If all files are put into folders, the rendering of the Files tab page is almost instantaneous - once the page is retrieved from the server.) Server end The retrieval of files from the server becomes very slow, apparently due to checking for files and permissions across many database tables, many times. In a very large group with GB of user content the group became unusable, with uploads taking 20 seconds or more. Suggestions The filebrowser seems to load all available files every time. Could we load only the files in the current folder, and load other files when required? Could we optimize the database query which returns the list of available files? Notes This issue is likely to occur in the users' personal upload space as well - I haven't tested that as yet. When working in groups where many files have been uploaded to the group space (hundreds or more), any part of the interface which uses the file browser slows significantly. For example when viewing the Files tab in the group, or when adding an Image content block to a group page. There are two aspects to this - the retrieval of the page from the server, and the rendering of the page in the browser. Both become significantly slower as more files are uploaded. Browser end In the Files tab in a group with about 250 files, the Mochiscript javascript starts throwing errors due to long processing time, when rendering the page in the browser. (Firefox 38). This appears to be due to the code which initializes drag and drop on files and folders. (If all files are put into folders, the rendering of the Files tab page is almost instantaneous - once the page is retrieved from the server.) Server end The retrieval of pages from the server becomes very slow, apparently due to checking for files and permissions across many database tables, many times. In a very large group with GB of user content the group became unusable, with uploads taking 20 seconds or more. Suggestions The filebrowser seems to load all available files every time. Could we load only the files in the current folder, and load other files when required? Could we optimize the database query which returns the list of available files? Notes This issue is likely to occur in the users' personal upload space as well - I haven't tested that as yet.
2015-07-13 08:17:36 Kristina Hoeppner mahara: status New Triaged
2015-07-13 08:17:40 Kristina Hoeppner mahara: importance Undecided Medium