topic What happens before a mySQL call when opening a space? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/what-happens-before-a-mysql-call-when-opening-a-space/m-p/228702#M181832 <HTML><HEAD></HEAD><BODY><SPAN>I am having big problems with speed while looking in spaces and accessing files (from the gui) from a clustered server, to the remote host (where the DB is located). </SPAN><BR /><BR /><SPAN>I'm using Alf 3.2 Community on a Fedora 12 machine that is connected remotely to a mySQL DB (Alf host).</SPAN><BR /><SPAN>To open a space with 10 other spaces inside it takes between 20-30 seconds, where on the host it takes about a second. </SPAN><BR /><BR /><SPAN>After doing a tcpdump I found that the mySQL call happens only during the last second before the space/data loads, so it looks like its not a DB issue. I am wondering if anyone knows what happens before the mySQL call is made and why it is slowing Alf down so much as to make it unusable? </SPAN><BR /><BR /><SPAN>From my understanding the lucene indexes simply tokenize items and add descriptions, do they have anything to do with slow speeds?</SPAN><BR /><BR /><SPAN>Thank you.</SPAN></BODY></HTML> Tue, 18 May 2010 18:45:51 GMT unknown-user 2010-05-18T18:45:51Z What happens before a mySQL call when opening a space? https://connect.hyland.com/t5/alfresco-archive/what-happens-before-a-mysql-call-when-opening-a-space/m-p/228702#M181832 I am having big problems with speed while looking in spaces and accessing files (from the gui) from a clustered server, to the remote host (where the DB is located). I'm using Alf 3.2 Community on a Fedora 12 machine that is connected remotely to a mySQL DB (Alf host).To open a space with 10 other s Tue, 18 May 2010 18:45:51 GMT https://connect.hyland.com/t5/alfresco-archive/what-happens-before-a-mysql-call-when-opening-a-space/m-p/228702#M181832 unknown-user 2010-05-18T18:45:51Z Re: What happens before a mySQL call when opening a space? https://connect.hyland.com/t5/alfresco-archive/what-happens-before-a-mysql-call-when-opening-a-space/m-p/228703#M181833 <HTML><HEAD></HEAD><BODY><SPAN>The problem persists, and I'm at a loss to explain what is going on.. any suggestion would be helpful to at least rule something out.</SPAN></BODY></HTML> Wed, 26 May 2010 14:40:28 GMT https://connect.hyland.com/t5/alfresco-archive/what-happens-before-a-mysql-call-when-opening-a-space/m-p/228703#M181833 unknown-user 2010-05-26T14:40:28Z Re: What happens before a mySQL call when opening a space? https://connect.hyland.com/t5/alfresco-archive/what-happens-before-a-mysql-call-when-opening-a-space/m-p/228704#M181834 <HTML><HEAD></HEAD><BODY><SPAN>I'm not entirely sure of the answer to the main question, but we solved the issue in the following thread.</SPAN><BR /><BR /><A href="http://forums.alfresco.com/en/viewtopic.php?f=9&amp;t=26791" rel="nofollow noopener noreferrer">http://forums.alfresco.com/en/viewtopic.php?f=9&amp;t=26791</A></BODY></HTML> Wed, 07 Jul 2010 13:13:54 GMT https://connect.hyland.com/t5/alfresco-archive/what-happens-before-a-mysql-call-when-opening-a-space/m-p/228704#M181834 unknown-user 2010-07-07T13:13:54Z