mahara-contributors team mailing list archive

[Mahara Bot <1415246@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/4221
Committed: http://gitorious.org/mahara/mahara/commit/e1ad58d028575e6696c74e76f7e0a5abc9ad680e
Submitter: Son Nguyen (son.nguyen@xxxxxxxxxxxxxxx)
Branch:    master

commit e1ad58d028575e6696c74e76f7e0a5abc9ad680e
Author: Son Nguyen <son.nguyen@xxxxxxxxxxxxxxx>
Date:   Wed Jan 28 12:20:34 2015 +1300

Add new index for the field 'itemid' on 'search_elasticsearch_queue'

Bug 1415246

Change-Id: I863596d10826fdd606b92a38bf89182b55a1717f
Signed-off-by: Son Nguyen <son.nguyen@xxxxxxxxxxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1415246

Title:
  Add an index for the field 'itemid' on 'search_elasticsearch_queue'
  table

Status in Mahara ePortfolio:
  In Progress

Bug description:
  Version: master (15.04), 1.10, 1.9, 1.8

  To improve the db query performance on the site using elasticsearch,
  we need to add the index for field 'itemid' on
  'search_elasticsearch_queue' table.

  Suggested by Mark Kirkwood

  via email

  Mark Kirkwood wrote:
  > Ok, after letting search_elasticsearch_queue fill up a bit I ran some
  > benchmarks both without and with and index on the itemid col. Difference
  > is remarkable (factor of 8 times more throughput)

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1415246/+subscriptions