Last modified: 2014-01-03 16:18:08 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T17210, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 15210 - OTRS searches take a very long time
OTRS searches take a very long time
Status: RESOLVED WONTFIX
Product: Wikimedia
Classification: Unclassified
OTRS (Other open bugs)
unspecified
All All
: Lowest normal with 6 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
: upstream
: 29698 (view as bug list)
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2008-08-17 16:01 UTC by NonvocalScream
Modified: 2014-01-03 16:18 UTC (History)
8 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description NonvocalScream 2008-08-17 16:01:47 UTC 
The interface is slow to call up tickets, and even slower to complete searches for text inside a ticket... "Search for this text inside the database and show me which tickets match it".
Comment 1 Aryeh Gregor (not reading bugmail, please e-mail directly) 2008-09-23 00:48:23 UTC 
OTRS 2.3.1 added support for fulltext search:

http://otrs.org/

Upgrading to that or better and enabling fulltext should make the problem a lot better.
Comment 2 Cary Bass 2008-09-29 23:12:36 UTC 
I support this upgrade, and suggest that we find a nice time to implement the change.  I will even avail myself on the date in question to help do the upgrade.
Comment 3 Daniel 2008-09-30 02:30:23 UTC 
Support :)
Comment 4 Casey Brown 2008-10-01 12:20:15 UTC 
(In reply to comment #3)
> Support :)
> 

*points to "Vote for this bug"* :P
Comment 5 Daniel 2008-10-01 12:23:55 UTC 
Shh you :)
Comment 6 Tim Starling 2009-01-31 08:30:17 UTC 
(In reply to comment #1)
> OTRS 2.3.1 added support for fulltext search:
> 
> http://otrs.org/

No, it didn't add support for fulltext search in any traditional sense. It adds an article_search table to index the article table, but it doesn't put any FULLTEXT indexes on it. Instead, it populates it with a list of words contained in each article, separated by spaces, and searches the table with LIKE '%word%'. I'm not sure if the performance improvement would make it worth doing.
Comment 7 Tim Starling 2009-03-17 07:54:23 UTC 
Submitted upstream: http://bugs.otrs.org/show_bug.cgi?id=3724
Comment 8 Casey Brown 2011-07-03 17:26:29 UTC 
*** Bug 29698 has been marked as a duplicate of this bug. ***
Comment 9 Andre Klapper 2012-12-12 15:14:29 UTC 
[Removing RESOLVED LATER as discussed in
http://lists.wikimedia.org/pipermail/wikitech-l/2012-November/064240.html .
Reopening and setting priority to "Lowest".
For future reference, please use either RESOLVED WONTFIX (for issues that will
not be fixed), or simply set lowest priority. Thanks a lot!]
Comment 10 Andre Klapper 2013-02-21 15:36:58 UTC 
Quick update: This issue is still unresolved in the upstream bugtracker of OTRS.
Comment 11 Jeff Green 2013-08-26 20:13:15 UTC 
We rolled out OTRS v3.2.9. Please reopen the ticket or create a new one if the new version suffers this problem.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links