topic How to eliminate Slow Queries and What are the reasons of Performance increase after Restructuring Documents inside Alfresco? in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/how-to-eliminate-slow-queries-and-what-are-the-reasons-of/m-p/44212#M18060 <HTML><HEAD></HEAD><BODY><P>My organization is using Alfresco 5.0d for Content Store Management. They used to store all the documents inside root folder. There are around 3 Lacs of documents inside root folder now. Alfresco is performing very slowly now.&nbsp;</P><P>I can see a lot of slow queries taking from 2 sec to 100 sec for performing db search for fetching metadata of documents.</P><P>I tried to do the&nbsp;restructuring of documents by organizing every 10k documents inside new folders. This drastically improved Alfresco Performance.</P><P>Is there is any kind of benefit in restructuring 3 lacs of documents in root folder to 30 folders containing 10k folders.</P><P>Still i see some of the 30 sec Solr Tracking Queries in my db logs, what should i do to eliminate these types of slow queries?</P><P>I have already&nbsp;tuned Postgresql and Alfresco.</P><P>Please Help.</P></BODY></HTML> Wed, 30 Jan 2019 11:03:57 GMT warcraft_2 2019-01-30T11:03:57Z How to eliminate Slow Queries and What are the reasons of Performance increase after Restructuring Documents inside Alfresco? https://connect.hyland.com/t5/alfresco-forum/how-to-eliminate-slow-queries-and-what-are-the-reasons-of/m-p/44212#M18060 My organization is using Alfresco 5.0d for Content Store Management. They used to store all the documents inside root folder. There are around 3 Lacs of documents inside root folder now. Alfresco is performing very slowly now.&nbsp;I can see a lot of slow queries taking from 2 sec to 100 sec for performi Wed, 30 Jan 2019 11:03:57 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-eliminate-slow-queries-and-what-are-the-reasons-of/m-p/44212#M18060 warcraft_2 2019-01-30T11:03:57Z