Thanks for the extremely useful answer. Some comments, questions here below.
On Friday 28 Jan 2005 16:38, you wrote: > No, only the BLOB/TEXT columns need to be moved to MyISAM. Yes, I thought of doing so. The drawback is that you de-normalise the database. Is that correct? There are 2 alternatives we should then consider: - extract the two important columns, put them in a separate MyISAM table, index the separate table, operate searches only on the separate table. Like having a "view", but permanent. - separate the original table, in two tables (columns which need to be indexed, columns which do not need to be indexed), operate the search only on the table with the relevant columns. I do not like it too much, because it spoils the structure of the database. From a logical point of view, the former is better. Furthermore, there is rollback. (By the way, how do you solve the rollback problem?) The latter consumes less disk space, performance wise is better. Do you see any other drawback / advantage? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
