FrontAccounting forum — Remove redundant indexes

Re: Remove redundant indexes

null@example.com (apmuthu) — Sun, 21 Dec 2014 17:06:12 +0000

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

null@example.com (apmuthu) — Sun, 21 Dec 2014 06:38:28 +0000

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

Re: Remove redundant indexes

null@example.com (apmuthu) — Sat, 20 Dec 2014 16:57:05 +0000

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

null@example.com (itronics) — Sat, 20 Dec 2014 16:28:31 +0000

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

Remove redundant indexes

null@example.com (apmuthu) — Thu, 11 Dec 2014 16:28:50 +0000

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.