Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.9
-
Fix Version/s: 4.7.10
-
Component/s: None
-
Labels:
-
Documentation Required?:None
-
Sprint:4.7.10 Performance
-
Funding Source:Contributed Code
Description
The query to determine if the DB is myIsam is taking a whopping 13 seconds. It seems the mysql config will affect the speed of 'SHOW TABLE STATUS ' queries
http://dba.stackexchange.com/questions/39993/show-table-status-very-slow-on-innodb
However, this alternate query
{{SELECT count
FROM information_schema.TABLES
WHERE ENGINE <> 'MyISAM'
AND TABLE_SCHEMA = ''" . CRM_Core_DAO::getDatabaseName() . "'
AND TABLE_NAME LIKE 'civicrm_%'
AND TABLE_NAME NOT LIKE 'civicrm_import_job_%'
AND TABLE_NAME NOT LIKE '%temp';}}
Saves 12.99 of those 13 seconds