https://connect.hyland.com/t5/alfresco-forum/alfresco-content-services-information-to-use-reader-database-for/m-p/488862#M40050 <P>Alfresco Content services platform connects to the DB cluster and that uses writer database for all transactions .</P><P>Is there any configuration which can be done to connect to reader DB instance for GET /search api calls so that we leverage reader DB and that would reduce some effort from writer DB as well .</P><P>We have solr which has just metadata (no full text indexes) and the response times of search transactions are increasing when we try to fetch the document metadata for a date range. For eg 2 month or 4 months date period. Our configuration is default "Use DB if possible"</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 09 Apr 2025 15:23:50 GMT ranjeetsi 2025-04-09T15:23:50Z https://connect.hyland.com/t5/alfresco-forum/alfresco-content-services-information-to-use-reader-database-for/m-p/488862#M40050 <P>Alfresco Content services platform connects to the DB cluster and that uses writer database for all transactions .</P><P>Is there any configuration which can be done to connect to reader DB instance for GET /search api calls so that we leverage reader DB and that would reduce some effort from writer DB as well .</P><P>We have solr which has just metadata (no full text indexes) and the response times of search transactions are increasing when we try to fetch the document metadata for a date range. For eg 2 month or 4 months date period. Our configuration is default "Use DB if possible"</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 09 Apr 2025 15:23:50 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-content-services-information-to-use-reader-database-for/m-p/488862#M40050 ranjeetsi 2025-04-09T15:23:50Z