1 Topic by apmuthu (edited by apmuthu 12/24/2014 01:24:17 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Topic: Remove redundant indexes

After FrontAccounting installation and in existing installations, remove redundant indexes using:

ALTER TABLE `0_cust_branch` DROP INDEX `branch_code`;
ALTER TABLE `0_supp_trans` DROP INDEX `supplier_id`;
ALTER TABLE `0_supp_trans` DROP INDEX `type`;
ALTER TABLE `0_supp_trans` DROP INDEX `SupplierID_2`, ADD INDEX `supplier_id` (`supplier_id`, `supp_reference`);

Change table prefix as needed and apply for all companies.

Read more about it here.

apmuthu's Website

  • Registered: 12/25/2007
  • Posts: 2,446

Re: Remove redundant indexes

Will be fixed in version 2.4. Thanks for pointing this.
Janusz

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Remove redundant indexes

It's easy to remove these in v2.3 itself. It practically does not affect any table structure or break any script processing.

apmuthu's Website

4 Reply by apmuthu (edited by apmuthu 12/21/2014 06:42:01 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Remove redundant indexes

Thanks for including the fix. Please correct it as per the attachment.

Post's attachments

Incomplete_Commit_Fix.png 26 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

5 Reply by apmuthu (edited by apmuthu 12/24/2014 01:33:41 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Remove redundant indexes

It did stand full fixed.

It has now been reverted (as of 2014-12-22) due to database schema policies on minor revisions and only these changes (en_US-New.sql, en_US-demo.sql) have been moved to the Unstable v2.4 branch where further redundant indexes still exist.

apmuthu's Website