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?
symbulos - ethical services for your organisation