Hi there,
Is there any common strategy (of using indexes)
to avoid filesorts while sorting searches by a field ?
Eg. I want fulltext search, then sort results by
some other table field.
For example .:
create table article (
id int not null primary key auto_increment,
sort1 int not null,
Since you are already splitting your data into fulltext columns and
other data I would keep that design. Others on the list have greatly
improved their performance by running their tables in this same fashion.
If by some chance your non-fulltext columns are all fixed width, there
is another
[EMAIL PROTECTED] wrote:
Since you are already splitting your data into fulltext columns and
other data I would keep that design. Others on the list have greatly
improved their performance by running their tables in this same
fashion. If by some chance your non-fulltext columns are all fixed