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?

  • To clarify, I mean the Assets page in the admin system is going very slow. – GlennJ Jul 9 '14 at 20:09
  • Edited your question, Glenn. – carlcs Jul 9 '14 at 20:11
  • Cheers Christian :) – GlennJ Jul 9 '14 at 20:12
  • Edited my answer below :) – carlcs Jul 9 '14 at 20:15
  • 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? – Brad Bell Jul 9 '14 at 21:53

The first step to diagnose would be to determine where the bottleneck is.

If you enable 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.