• Resolved john brown

    (@alihan1988)


    I’am using Query Monitor plugin and I testing my site performance. But, Your database creation function runs every page load. I’ve checked the database and a_auto_updates created before and not empty.

    Please configure and reduce these queries to work with hourly cronjob only.

    I see these queries every page load:
    ———-

    
    Query - Caller - Component - Rows - Time
    
    9	ALTER TABLE a_auto_updates CHANGE COLUMN <code>id</code> id INT(9) NOT NULL AUTO_INCREMENT	
    cau_database_creation()
    +	Plugin: companion-auto-update	1	0.0103
    10	ALTER TABLE a_auto_updates CHANGE COLUMN <code>name</code> name VARCHAR(255) NOT NULL	
    cau_database_creation()
    +	Plugin: companion-auto-update	1	0.0036
    11	ALTER TABLE a_auto_updates CHANGE COLUMN <code>onoroff</code> onoroff VARCHAR(255) NOT NULL	
    cau_database_creation()
    +	Plugin: companion-auto-update	1	0.0087
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘cau_database_creation() ALTER TABLE … runs every time’ is closed to new replies.