Answers.Body: <p>The first step to diagnose would be to determine where the bottleneck is.</p>
  
  <p>If you enable <a href="http://buildwithcraft.com/docs/config-settings#devMode" rel="nofollow">devMode</a>, you'll see database profiling information in your browser's console, including the SQL executed for each query along with the total number of queries executed.</p>
  
  <p>Those queries will be ordered by the slowest performing ones at the top.  If there are multiple, slow performing queries that are taking up the majority of the time it takes to load the page, then there is likely something we could do in Craft to optimize performance in your scenario and you should contact us at support@buildwithcraft.com and send along a database dump so we can try to reproduce.</p>
  
  <p>If the database queries look like they are not the issue, then the next likely culprit is disc access times.  If these folders/files are in the cloud (S3, Rackspace, etc.), or you're using NFS for your file system, then those could be slowing down the request as well.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2014-07-12T20:25:53.893Z
Answers.LastActivityDate: 2014-07-12T20:25:53.893Z
Answers.UserDisplayName: Brad Bell
Body: <p>Our client has created a lot of folders and sub-folders to keep their assets organised. I would guess they've made around 700 to 800!! (Basically two folders for each post)</p>
  
  <p>The assets page in the CP loads very slow now - is there anything I can do to speed this up?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-07-09T20:09:17.387Z
Comments.Text: To clarify, I mean the Assets page in the admin system is going very slow.
Comments.UserDisplayName: GlennJ
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-07-09T20:11:30.603Z
Comments.Text: Edited your question, Glenn.
Comments.UserDisplayName: carlcs
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-07-09T20:12:48.083Z
Comments.Text: Cheers Christian :)
Comments.UserDisplayName: GlennJ
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-07-09T20:15:01.887Z
Comments.Text: Edited my answer below :)
Comments.UserDisplayName: carlcs
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-07-09T20:20:30.730Z
Comments.Text: Sorry Glenn, I misread your text again! This time I definitely have no answer :) I'll delete all the below to attract more others!
Comments.UserDisplayName: carlcs
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-07-09T20:23:01.950Z
Comments.Text: Thanks for trying anyhow! I'm guessing there's a SQL query running for each folder which is causing the slowdown.
Comments.UserDisplayName: GlennJ
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-07-09T20:34:43.660Z
Comments.Text: I profiled the CP admin page, and it runs 432 DB queries - too many I would suggest.
Comments.UserDisplayName: GlennJ
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-07-09T21:53:44.170Z
Comments.Text: The profiler shows the total number of queries, but it's also sorted by the worst performing ones at the top... how long are those taking to execute?
Comments.UserDisplayName: Brad Bell
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-07-12T05:43:00.577Z
Comments.Text: Have you identified the bottleneck yet?
Comments.UserDisplayName: Tyler Willingham
Tags: <assets><control-panel>
Title: Slow Assets Listing in CP
ThreadText: # Slow Assets Listing in CP
  
  (Asked by: username_0 on 2014-07-09)
  
  Our client has created a lot of folders and sub-folders to keep their assets organised. I would guess they've made around 700 to 800!! (Basically two folders for each post)
  
  The assets page in the CP loads very slow now - is there anything I can do to speed this up?
  
  **Tags:** assets, control-panel
  
  > **Comments:**
  > **username_0**: To clarify, I mean the Assets page in the admin system is going very slow.  
  > **username_1**: Edited your question, Glenn.  
  > **username_0**: Cheers Christian :)  
  > **username_1**: Edited my answer below :)  
  > **username_1**: Sorry Glenn, I misread your text again! This time I definitely have no answer :) I'll delete all the below to attract more others!  
  > **username_0**: Thanks for trying anyhow! I'm guessing there's a SQL query running for each folder which is causing the slowdown.  
  > **username_0**: I profiled the CP admin page, and it runs 432 DB queries - too many I would suggest.  
  > **username_2**: The profiler shows the total number of queries, but it's also sorted by the worst performing ones at the top... how long are those taking to execute?  
  > **username_3**: Have you identified the bottleneck yet?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2014-07-12. Score: 4
  
  The first step to diagnose would be to determine where the bottleneck is.
  
  If you enable [devMode](http://buildwithcraft.com/docs/config-settings#devMode), you'll see database profiling information in your browser's console, including the SQL executed for each query along with the total number of queries executed.
  
  Those queries will be ordered by the slowest performing ones at the top. If there are multiple, slow performing queries that are taking up the majority of the time it takes to load the page, then there is likely something we could do in Craft to optimize performance in your scenario and you should contact us at support@buildwithcraft.com and send along a database dump so we can try to reproduce.
  
  If the database queries look like they are not the issue, then the next likely culprit is disc access times. If these folders/files are in the cloud (S3, Rackspace, etc.), or you're using NFS for your file system, then those could be slowing down the request as well.
  
  
  ---
  
  