Hello Michiel, Thanks for your answer. How do I configure the system to use disk files instead of blob fields?
Regards, Bart -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Meeuwissen Sent: dinsdag 3 oktober 2006 13:26 To: Discussion list for designers (front-end) Subject: Re: [Users] Performance issue mmbase Bart De Man wrote: > > 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). That would certainly be worth a try, and my first suggestion. It's also more comfortable for the db-backup. Michiel -- Michiel Meeuwissen mihxil' Peperbus 107 MediaPark H'sum []() +31 (0)35 6772979 nl_NL eo_XX en_US _______________________________________________ Users mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/users
