** Changed in: mahara
Status: Fix Committed => Fix Released
--
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:
Fix Released
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
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
