Task #822
Add fulltext index to hlstats_playernames on name
| Status: | Closed | Start date: | 11/17/2009 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Packhead |
% Done: | 0% |
|
| Category: | General | |||
| Target version: | 1.6.3 | Estimated time: | 1.00 hour | |
| Blocking Target Version: |
Description
^ what he said.
This makes searching for player names quite a bit more snappy. Should be a pretty straightforward addition to the upgrade SQL.
History
#1
Updated by Packhead over 2 years ago
- Category set to General
- Status changed from New to Assigned
- Assignee set to Packhead
#2
Updated by Packhead over 2 years ago
- Status changed from Assigned to UserFeedback
I added a fulltext index for the player name and it didnt seem to have any impact on generation time for the SQL. We're currently making an index on name -- which having it didn't seem to affect my performance either (when I removed it).
Sure we need this?
#3
Updated by Packhead over 2 years ago
- Status changed from UserFeedback to Closed
<agent86> in reading the manual, it seems like I was mistaken about whether a fulltext index would help in this case
<agent86> so Packhead, you can close that issue, I was incorrect