{"id":11491,"date":"2009-01-19T20:22:02","date_gmt":"2009-01-19T18:22:02","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=11491"},"modified":"2009-01-19T20:22:02","modified_gmt":"2009-01-19T18:22:02","slug":"fixing-advanced-search-performance-in-rt3","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/","title":{"rendered":"Fixing advanced search performance in RT3"},"content":{"rendered":"<!-- google_ad_section_start -->\n<p>It&#8217;s been bugging me for a while now that advanced search is extremely slow in our <a href=\"http:\/\/bestpractical.com\/rt\/\">RT3<\/a>.\u00a0 I thought it was something related to the <a href=\"http:\/\/linux.slashdot.org\/article.pl?sid=08\/08\/29\/1423201&amp;from=rss\">famous Perl bug<\/a>, but apparently it wasn&#8217;t.\u00a0 Then I was I waiting for Fedora 10 to come out, so that we&#8217;d upgrade our RT3 installation to version 3.8.\u00a0 And that didn&#8217;t solve the problem either.\u00a0 Finally, we got bored and annoyed enough by this problem to actually do soemthing about it.\u00a0 The solution was, as often, just a Google search away.\u00a0 Here is the quote from <a href=\"http:\/\/www.gossamer-threads.com\/lists\/rt\/users\/76792?search_string=query%20build;#76792\">this discussion<\/a>:<\/p>\n<blockquote><p>Faulty rights on a specific queue caused the owner list to be quite long, which RT didn&#8217;t like. (By mistake someone had given the own ticket right on the queue to all unprivileged users)<\/p><\/blockquote>\n<p>I went through all the queues to check the rights, and there it was &#8211; a test queue had &#8220;Own Ticket&#8221; assigned to &#8220;Everyone&#8221;.\u00a0 Immediately, after remove this access levels things got back to normal.<\/p>\n<!-- google_ad_section_end -->\n","protected":false},"excerpt":{"rendered":"<!-- google_ad_section_start -->\n<p>It&#8217;s been bugging me for a while now that advanced search is extremely slow in our RT3.\u00a0 I thought it was something related to the famous Perl bug, but apparently it wasn&#8217;t.\u00a0 Then I was I waiting for Fedora 10 to come out, so that we&#8217;d upgrade our RT3 installation to version 3.8.\u00a0 And that &hellip; <a href=\"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Fixing advanced search performance in RT3<\/span><\/a><\/p>\n<!-- google_ad_section_end -->\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_links_to":"","_links_to_target":""},"categories":[1,133],"tags":[1057,3150,335],"keyring_services":[],"class_list":["post-11491","post","type-post","status-publish","format-standard","hentry","category-general","category-sysadmin","tag-performance","tag-request-tracker","tag-search"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"It&#039;s been bugging me for a while now that advanced search is extremely slow in our RT3. I thought it was something related to the famous Perl bug, but apparently it wasn&#039;t. Then I was I waiting for Fedora 10 to come out, so that we&#039;d upgrade our RT3 installation to version 3.8. And that\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Leonid Mamchenkov\"\/>\n\t<meta name=\"google-site-verification\" content=\"VHvdD0_usx1_4DzKy_QCVcICVgX2EgA2ybELT-wl7kQ\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Leonid Mamchenkov - Life, universe, and everything else\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Fixing advanced search performance in RT3 - Leonid Mamchenkov\" \/>\n\t\t<meta property=\"og:description\" content=\"It&#039;s been bugging me for a while now that advanced search is extremely slow in our RT3. I thought it was something related to the famous Perl bug, but apparently it wasn&#039;t. Then I was I waiting for Fedora 10 to come out, so that we&#039;d upgrade our RT3 installation to version 3.8. And that\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2009-01-19T18:22:02+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2009-01-19T18:22:02+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MamchenkovBlog\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@mamchenkov\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Fixing advanced search performance in RT3 - Leonid Mamchenkov\" \/>\n\t\t<meta name=\"twitter:description\" content=\"It&#039;s been bugging me for a while now that advanced search is extremely slow in our RT3. I thought it was something related to the famous Perl bug, but apparently it wasn&#039;t. Then I was I waiting for Fedora 10 to come out, so that we&#039;d upgrade our RT3 installation to version 3.8. And that\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@mamchenkov\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#blogposting\",\"name\":\"Fixing advanced search performance in RT3 - Leonid Mamchenkov\",\"headline\":\"Fixing advanced search performance in RT3\",\"author\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"Leonid Mamchenkov\"},\"datePublished\":\"2009-01-19T20:22:02+02:00\",\"dateModified\":\"2009-01-19T20:22:02+02:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#webpage\"},\"articleSection\":\"All, Sysadmin, performance, Request Tracker, search\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/#listItem\",\"name\":\"Technology\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/#listItem\",\"position\":2,\"name\":\"Technology\",\"item\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/sysadmin\\\/#listItem\",\"name\":\"Sysadmin\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/sysadmin\\\/#listItem\",\"position\":3,\"name\":\"Sysadmin\",\"item\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/sysadmin\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#listItem\",\"name\":\"Fixing advanced search performance in RT3\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/#listItem\",\"name\":\"Technology\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#listItem\",\"position\":4,\"name\":\"Fixing advanced search performance in RT3\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/sysadmin\\\/#listItem\",\"name\":\"Sysadmin\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#person\",\"name\":\"Leonid Mamchenkov\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"Leonid Mamchenkov\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/\",\"name\":\"Leonid Mamchenkov\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"Leonid Mamchenkov\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#webpage\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/\",\"name\":\"Fixing advanced search performance in RT3 - Leonid Mamchenkov\",\"description\":\"It's been bugging me for a while now that advanced search is extremely slow in our RT3. I thought it was something related to the famous Perl bug, but apparently it wasn't. Then I was I waiting for Fedora 10 to come out, so that we'd upgrade our RT3 installation to version 3.8. And that\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2009\\\/01\\\/19\\\/fixing-advanced-search-performance-in-rt3\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\"},\"datePublished\":\"2009-01-19T20:22:02+02:00\",\"dateModified\":\"2009-01-19T20:22:02+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/\",\"name\":\"Blog of Leonid Mamchenkov\",\"description\":\"Life, universe, and everything else\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Fixing advanced search performance in RT3 - Leonid Mamchenkov","description":"It's been bugging me for a while now that advanced search is extremely slow in our RT3. I thought it was something related to the famous Perl bug, but apparently it wasn't. Then I was I waiting for Fedora 10 to come out, so that we'd upgrade our RT3 installation to version 3.8. And that","canonical_url":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"VHvdD0_usx1_4DzKy_QCVcICVgX2EgA2ybELT-wl7kQ","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#blogposting","name":"Fixing advanced search performance in RT3 - Leonid Mamchenkov","headline":"Fixing advanced search performance in RT3","author":{"@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author"},"publisher":{"@id":"https:\/\/mamchenkov.net\/wordpress\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g","width":96,"height":96,"caption":"Leonid Mamchenkov"},"datePublished":"2009-01-19T20:22:02+02:00","dateModified":"2009-01-19T20:22:02+02:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#webpage"},"isPartOf":{"@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#webpage"},"articleSection":"All, Sysadmin, performance, Request Tracker, search"},{"@type":"BreadcrumbList","@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress#listItem","position":1,"name":"Home","item":"https:\/\/mamchenkov.net\/wordpress","nextItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/#listItem","name":"Technology"}},{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/#listItem","position":2,"name":"Technology","item":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/","nextItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/sysadmin\/#listItem","name":"Sysadmin"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/sysadmin\/#listItem","position":3,"name":"Sysadmin","item":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/sysadmin\/","nextItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#listItem","name":"Fixing advanced search performance in RT3"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/#listItem","name":"Technology"}},{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#listItem","position":4,"name":"Fixing advanced search performance in RT3","previousItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/sysadmin\/#listItem","name":"Sysadmin"}}]},{"@type":"Person","@id":"https:\/\/mamchenkov.net\/wordpress\/#person","name":"Leonid Mamchenkov","image":{"@type":"ImageObject","@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g","width":96,"height":96,"caption":"Leonid Mamchenkov"}},{"@type":"Person","@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author","url":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/","name":"Leonid Mamchenkov","image":{"@type":"ImageObject","@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g","width":96,"height":96,"caption":"Leonid Mamchenkov"}},{"@type":"WebPage","@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#webpage","url":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/","name":"Fixing advanced search performance in RT3 - Leonid Mamchenkov","description":"It's been bugging me for a while now that advanced search is extremely slow in our RT3. I thought it was something related to the famous Perl bug, but apparently it wasn't. Then I was I waiting for Fedora 10 to come out, so that we'd upgrade our RT3 installation to version 3.8. And that","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/mamchenkov.net\/wordpress\/#website"},"breadcrumb":{"@id":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/#breadcrumblist"},"author":{"@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author"},"creator":{"@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author"},"datePublished":"2009-01-19T20:22:02+02:00","dateModified":"2009-01-19T20:22:02+02:00"},{"@type":"WebSite","@id":"https:\/\/mamchenkov.net\/wordpress\/#website","url":"https:\/\/mamchenkov.net\/wordpress\/","name":"Blog of Leonid Mamchenkov","description":"Life, universe, and everything else","inLanguage":"en-US","publisher":{"@id":"https:\/\/mamchenkov.net\/wordpress\/#person"}}]},"og:locale":"en_US","og:site_name":"Leonid Mamchenkov - Life, universe, and everything else","og:type":"article","og:title":"Fixing advanced search performance in RT3 - Leonid Mamchenkov","og:description":"It's been bugging me for a while now that advanced search is extremely slow in our RT3. I thought it was something related to the famous Perl bug, but apparently it wasn't. Then I was I waiting for Fedora 10 to come out, so that we'd upgrade our RT3 installation to version 3.8. And that","og:url":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/","og:image":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg","og:image:secure_url":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg","og:image:width":1024,"og:image:height":1024,"article:published_time":"2009-01-19T18:22:02+00:00","article:modified_time":"2009-01-19T18:22:02+00:00","article:publisher":"https:\/\/www.facebook.com\/MamchenkovBlog","twitter:card":"summary_large_image","twitter:site":"@mamchenkov","twitter:title":"Fixing advanced search performance in RT3 - Leonid Mamchenkov","twitter:description":"It's been bugging me for a while now that advanced search is extremely slow in our RT3. I thought it was something related to the famous Perl bug, but apparently it wasn't. Then I was I waiting for Fedora 10 to come out, so that we'd upgrade our RT3 installation to version 3.8. And that","twitter:creator":"@mamchenkov","twitter:image":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg"},"aioseo_meta_data":{"post_id":"11491","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-07-19 21:16:36","updated":"2026-01-15 04:03:46","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mamchenkov.net\/wordpress\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/\" title=\"Technology\">Technology<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/sysadmin\/\" title=\"Sysadmin\">Sysadmin<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tFixing advanced search performance in RT3\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/mamchenkov.net\/wordpress"},{"label":"Technology","link":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/"},{"label":"Sysadmin","link":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/sysadmin\/"},{"label":"Fixing advanced search performance in RT3","link":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/"}],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":12664,"url":"https:\/\/mamchenkov.net\/wordpress\/2010\/07\/05\/integrating-rt3-with-subversion\/","url_meta":{"origin":11491,"position":0},"title":"Integrating RT3 with Subversion","author":"Leonid Mamchenkov","date":"July 5, 2010","format":false,"excerpt":"As I have mentioned a few times before, I am a big fan of using BestPractical RT3 for all sorts of things, including, but not limited to, bug tracking during project development. \u00a0I see a great benefit in having a single system for both technical support and development departments. \u00a0Bugs\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/07\/commits_chart.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":14695,"url":"https:\/\/mamchenkov.net\/wordpress\/2011\/03\/28\/rt3-automatically-assign-owner-by-queue\/","url_meta":{"origin":11491,"position":1},"title":"RT3 : Automatically assign owner by queue","author":"Leonid Mamchenkov","date":"March 28, 2011","format":false,"excerpt":"There is one bit of functionality that I keep reusing for pretty much every installation of RT3 - automatic assignment of tickets to specific users based on queue. \u00a0There are a few solutions to this problem and some are documented in RT3 wiki. \u00a0But I always keep forgetting which solution\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11449,"url":"https:\/\/mamchenkov.net\/wordpress\/2008\/12\/08\/fixing-rt3-on-fedora-10\/","url_meta":{"origin":11491,"position":2},"title":"Fixing RT3 on Fedora 10","author":"Leonid Mamchenkov","date":"December 8, 2008","format":false,"excerpt":"We upgraded our development server to Fedora 10 over the weekend.\u00a0 Among other things, it runs RT3 - excellent support, issue management, and bug tracking tool.\u00a0 Once the upgrade was over, we ended up with a semi-working setup of RT3.\u00a0 The emails were going through just fine, but the web\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":12633,"url":"https:\/\/mamchenkov.net\/wordpress\/2010\/06\/23\/mantisbt-vs-rt3\/","url_meta":{"origin":11491,"position":3},"title":"MantisBT vs. RT3","author":"Leonid Mamchenkov","date":"June 23, 2010","format":false,"excerpt":"I've been praising Best Pratical's RT3 (aka Request Tracker) for a long time. \u00a0So at my new job, given a new start, I thought that I maybe need to explore other options and widen my horizons. \u00a0After all, the needs were much less and much simpler. \u00a0We just needed a\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11752,"url":"https:\/\/mamchenkov.net\/wordpress\/2009\/09\/05\/daily-tweets-digest\/","url_meta":{"origin":11491,"position":4},"title":"Daily tweets digest","author":"Leonid Mamchenkov","date":"September 5, 2009","format":false,"excerpt":"Our RT3 ticketing system just got its 400,000 ticket. Awesome! Worthy of a celebration. # On the way to Pafos. Will get drunk. Don't need to drive. Sweet! # Stopped for steak and beer, before the real drinking. #","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10751,"url":"https:\/\/mamchenkov.net\/wordpress\/2007\/07\/04\/daily-tweets\/","url_meta":{"origin":11491,"position":5},"title":"Daily tweets","author":"Leonid Mamchenkov","date":"July 4, 2007","format":false,"excerpt":"making a weak attempt to catch up with feeds... at least with personal stuff # Trying to figure out a way to have time tracking in RT3. Per person, per ticket, per parent ticket. # In less than two month our repository grew over 1,000 commits. And we haven't even\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/11491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=11491"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/11491\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=11491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=11491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=11491"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=11491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}