Author: Dickson.Tam

Description:
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;

1. Time: 060413 10:37:09
2. User@Host: wikiuser[wikiuser] @ localhost [127.0.0.1]
3. Query_time: 2 Lock_time: 0 Rows_sent: 13 Rows_examined: 13

DESCRIBE /* Database::fieldExists */ wikiimage;

1. Time: 060413 10:37:12
2. User@Host: wikiuser[wikiuser] @ localhost [127.0.0.1]
3. Query_time: 2 Lock_time: 0 Rows_sent: 13 Rows_examined: 13

DESCRIBE /* Database::fieldExists */ wikiimage;

1. Time: 060413 10:37:15
2. User@Host: wikiuser[wikiuser] @ localhost [127.0.0.1]
3. Query_time: 2 Lock_time: 0 Rows_sent: 13 Rows_examined: 13

DESCRIBE /* Database::fieldExists */ wikiimage;

1. Time: 060413 10:37:18
2. User@Host: wikiuser[wikiuser] @ localhost [127.0.0.1]
3. Query_time: 2 Lock_time: 0 Rows_sent: 13 Rows_examined: 13

DESCRIBE /* Database::fieldExists */ wikiimage;

Version: 1.6.x
Severity: normal
OS: Windows Server 2003
Platform: PC