Bug #3402 | Extremely bad order by performance on 'text' fields | ||
---|---|---|---|
Submitted: | 6 Apr 2004 16:17 | Modified: | 8 Apr 2004 8:07 |
Reporter: | Peter van Dijk | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.0.18 | OS: | Any (any) |
Assigned to: | Dean Ellis | CPU Architecture: | Any |
[6 Apr 2004 16:17]
Peter van Dijk
[8 Apr 2004 8:07]
Dean Ellis
mysqld does not know in advance that your TEXT data is actually quite short, so it uses the value of your max_sort_length server parameter for sorting TEXT columns. If you know that your data is significantly shorter than this (the default is 1024 bytes, per TEXT column being sorted, per row) then you can set this to a smaller value.