? Pending

User tests: Successful: Unsuccessful:

avatar alikon
alikon
15 Oct 2018

Pull Request for Issue #22625 .

Summary of Changes

added indexes

Testing Instructions

see #22625

avatar alikon alikon - open - 15 Oct 2018
avatar alikon alikon - change - 15 Oct 2018
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 15 Oct 2018
Category SQL Installation Postgresql MS SQL
avatar PhilETaylor
PhilETaylor - comment - 15 Oct 2018

Please also add

ALTER TABLE `#__action_logs` ADD INDEX (`extension`, `item_id`);
avatar alikon
alikon - comment - 15 Oct 2018

i'll consider it too as well,....
in the meantime can you share some metrics with and without the indexes...

avatar PhilETaylor
PhilETaylor - comment - 15 Oct 2018

in the meantime can you share some metrics with and without the indexes...

I did here #22625 (comment)

There is no point in even looking at metrics - the table had ZERO optimisation at all !

7393612 15 Oct 2018 avatar alikon oops
avatar alikon alikon - change - 15 Oct 2018
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - change - 15 Oct 2018
Category SQL Installation Postgresql MS SQL SQL Administration com_admin Installation Postgresql MS SQL
avatar alikon alikon - change - 15 Oct 2018
The description was changed
avatar alikon alikon - edited - 15 Oct 2018
4b0f5d6 15 Oct 2018 avatar alikon align
avatar mbabker mbabker - change - 24 Oct 2018
Status Pending Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 2018-10-24 21:56:26
Closed_By mbabker
avatar mbabker mbabker - close - 24 Oct 2018
avatar mbabker mbabker - merge - 24 Oct 2018

Add a Comment

Login with GitHub to post a comment