<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>

CC BY-SA 3.0
2014-07-12T20:25:53.893Z
2014-07-12T20:25:53.893Z
Brad Bell
<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>

CC BY-SA 3.0
2014-07-09T20:09:17.387Z
To clarify, I mean the Assets page in the admin system is going very slow.
GlennJ
CC BY-SA 3.0
2014-07-09T20:11:30.603Z
Edited your question, Glenn.
carlcs
CC BY-SA 3.0
2014-07-09T20:12:48.083Z
Cheers Christian :)
GlennJ
CC BY-SA 3.0
2014-07-09T20:15:01.887Z
Edited my answer below :)
carlcs
CC BY-SA 3.0
2014-07-09T20:20:30.730Z
Sorry Glenn, I misread your text again! This time I definitely have no answer :) I'll delete all the below to attract more others!
carlcs
CC BY-SA 3.0
2014-07-09T20:23:01.950Z
Thanks for trying anyhow! I'm guessing there's a SQL query running for each folder which is causing the slowdown.
GlennJ
CC BY-SA 3.0
2014-07-09T20:34:43.660Z
I profiled the CP admin page, and it runs 432 DB queries - too many I would suggest.
GlennJ
CC BY-SA 3.0
2014-07-09T21:53:44.170Z
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?
Brad Bell
CC BY-SA 3.0
2014-07-12T05:43:00.577Z
Have you identified the bottleneck yet?
Tyler Willingham
<assets><control-panel>
Slow Assets Listing in CP
# 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.


---

