[greenday2k]

This query used at least on the modify album on coppermine
is taking 10 seconds each time. Ive copied the query and executed on phpMyAdmin and it executed on: 10.6091

On site:

10.6443 - LINE 329:
modules/coppermine/modifyalb.php

Code:

SELECT aid, IF(username IS NOT NULL, CONCAT('(', username, ') ', title), CONCAT(' - ', title)) AS title FROM cms_cpg_albums AS a LEFT JOIN cms_users AS u ON category = (10000 + user_id) ORDER BY title

Also the same query was executed on 10 seconds after the database was optimizated.

Any clues?
Will a purge on users table make this query faster?
cms_users has 19,208 records. (19,208 reg users)

[greenday2k]

function alb_list_box() {
global $db,$CONFIG, $album, $CPG_URL, $file, $module_name;

if (GALLERY_ADMIN_MODE) {
$sql = "SELECT aid, IF(username IS NOT NULL, CONCAT('(', username, ') ', title), CONCAT(' - ', title)) AS title " . "FROM {$CONFIG['TABLE_ALBUMS']} AS a " . "LEFT JOIN {$CONFIG['TABLE_USERS']} AS u ON category = (" . FIRST_USER_CAT . " + user_id) " . "ORDER BY title";
$result = $db->sql_query($sql, false,__FILE__,__LINE__);
} else {
$result = $db->sql_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = '" . (FIRST_USER_CAT + USER_ID) . "' ORDER BY title", false,__FILE__,__LINE__);
}

[greenday2k]

Never mind, updated file to version 9.5
issues solved, is time to update my site xD