Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Artio SEF and mySql load
(1 viewing) (1) Guest
Support forum for users using free edition of JoomSEF 3 (Joomla 1.5 compatible). These forums are mainly for mutual help between users.

Please note that due to our capacity limitations, we do not monitor these forums regularly.

TOPIC: Artio SEF and mySql load

Re:Artio SEF and mySql load 18 years, 3 months ago #327

  • Hector Sanchez
Hello,

can I make the changes in the php.ini file? I tried to find the my.ini file and I coudn't find it

Regards,
Hector

cpu patch fix? 18 years, 3 months ago #351

  • joost
still running at high CPU


SELECT newurl FROM mos_redirection WHERE oldurl =

isn.t there a patch to fix it? my admin is getting crazy!!

greet, joost

Re:cpu patch fix? 18 years, 2 months ago #364

  • miun
  • OFFLINE
  • A pesimist is just a well-informed realist.
  • Posts: 563
Hello,

try adding an index to 'oldurl' column in #_redirection table. This should help. This issue is to be fixed in the next release of JoomSEF, but meanwhile, you may do this manually:

CREATE INDEX `oldurl` ON `jos_redirection` (`oldurl`);



Best regards,
Michal Unzeitig
ARTIO Support Team

Re:cpu patch fix? 18 years, 2 months ago #387

  • joost
thans for the reply! I''ll try the code

Re:cpu patch fix? 18 years, 2 months ago #390

  • delusion
that piece of code is there already, still it's slow and trust me, my sites don't run on an old p-o-c server..

Re:cpu patch fix? 18 years, 2 months ago #427

  • nibra
One thing I found is that the caching of the iso retrieval does not work. I rewrote the SEFTools class to fix that:

 
class SEFTools
{
 
/** Retrieves the language ID from the given language name
*
* @param string Code language name (normally $mosConfig_lang)
* @return int Database id of this language
*/

function getLangCode($langName = null)
{
global $database, $mosConfig_lang;
// <mod package="BugFix" author="Niels Braczek" date="2006-10-05">--------------
// Caching did not work
static $langCode = array();
 
if ( empty( $langName ) ) {
$langName = $mosConfig_lang;
}
if ( isset( $langCode[$langName] ) ) {
return $langCode[$langName];
}
$sql = "SELECT iso FROM #__languages WHERE active=1 AND code='$langName' ORDER BY ordering";
$database->setQuery( $sql );
$langCode[$langName] = $database->loadResult( false );
 
return $langCode[$langName];
// original code:
// static $sLangName, $langCode;
//
// if (is_null($langName)) $langName = $mosConfig_lang;
// if ($sLangName == $langName && isset($langCode)) return $langCode;
// $langCode = -1;
// if ($langName != '') {
// $database->setQuery("SELECT iso FROM #__languages WHERE active=1 and code = '$langName' order by ordering"«»);
// $langCode = $database->loadResult(false);
// }
// return $langCode;
// </mod>-----------------------------------------------------------------------
}
 
}
 


HTH
Niels
User Login Empty