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 Users@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/users
