FrontAccounting forum — Remove redundant indexes

Re: Remove redundant indexes

2014-12-21T17:06:12Z

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.

Re: Remove redundant indexes

2014-12-21T06:38:28Z

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

Re: Remove redundant indexes

2014-12-20T16:57:05Z

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

Re: Remove redundant indexes

2014-12-20T16:28:31Z

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

Remove redundant indexes

2014-12-11T16:28:50Z

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.