Last modified: 2010-05-15 15:56:41 UTC
Saving templates, even simple ones are extremely show. My SQL slow queries log shows multiple describe image tables requests submitted for a single template page save that take over 2 sec to execute. This results in the page operation timing out due to the 30 sec. limitation. Several notes: 1) The template page does not refer to an image, so I don't get why describe `wikiimage` is called multiple times. 2) Describe `wikiimage` executes fine (~0.01 sec.) using the mysql command line client Slow queries ------------ DESCRIBE /* Database::fieldExists */ `wikiimage`; # Time: 060413 10:37:09 # User@Host: wikiuser[wikiuser] @ localhost [127.0.0.1] # Query_time: 2 Lock_time: 0 Rows_sent: 13 Rows_examined: 13 DESCRIBE /* Database::fieldExists */ `wikiimage`; # Time: 060413 10:37:12 # User@Host: wikiuser[wikiuser] @ localhost [127.0.0.1] # Query_time: 2 Lock_time: 0 Rows_sent: 13 Rows_examined: 13 DESCRIBE /* Database::fieldExists */ `wikiimage`; # Time: 060413 10:37:15 # User@Host: wikiuser[wikiuser] @ localhost [127.0.0.1] # Query_time: 2 Lock_time: 0 Rows_sent: 13 Rows_examined: 13 DESCRIBE /* Database::fieldExists */ `wikiimage`; # Time: 060413 10:37:18 # User@Host: wikiuser[wikiuser] @ localhost [127.0.0.1] # Query_time: 2 Lock_time: 0 Rows_sent: 13 Rows_examined: 13 DESCRIBE /* Database::fieldExists */ `wikiimage`;
