[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 fix
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 anoth
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,