Hello, We have an MMBase site running for about 3 years now. Over the last several months, we have been encountering performance issues with handling Documents. More specifically we encounter "Socket closed" exceptions in the editwizard when trying to get the list of Documents.
We have about 2500 records in the install_Documents table, which is about 1GB in size. We have found the problem to be the query that is generated by the editwizards when calling the list of Documents: SELECT install_CN_Document.number,install_CN_Document.otype,install_CN_Document.own er,install_CN_Document.lastmodifiedTS,install_CN_Document.lastchangedby,inst all_CN_Document.createdTS,install_CN_Document.createdby,install_CN_Document. title,install_CN_Document.description,install_CN_Document.mimetype,install_C N_Document.filename,install_CN_Document.size FROM install_CN_Document ORDER BY lastmodifiedTS DESC This query takes more than 90 seconds to run (on a fast and idle server). The problem might be related to the blob-fields in the table: although they are not selected, they still seem to cause delay. We use mysql 4.0, MyIsam tables. Do you have any suggestions to a solution? Can we for example switch to disk file based storage for these Documents (=attachments). Thanks a lot, Bart De Man _______________________________________________ Users mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/users
