Artio SEF and mySql load

Welcome, Guest

(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.

Reply Topic

New Topic

Page:
1
2
3

TOPIC: Artio SEF and mySql load

Re:Artio SEF and mySql load 18 years, 2 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
	Reply Quote

cpu patch fix? 18 years, 2 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
	Reply Quote

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 Reply Quote

Re:cpu patch fix? 18 years, 1 month ago #387

joost	thans for the reply! I''ll try the code
	Reply Quote

Re:cpu patch fix? 18 years, 1 month 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..
	Reply Quote

Re:cpu patch fix? 18 years, 1 month 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;
// &lt;mod package=&quot;BugFix&quot; author=&quot;Niels Braczek&quot; date=&quot;2006-10-05&quot;&gt;--------------
        // Caching did not work
        static $langCode = array();
 
        if ( empty( $langName ) ) {
            $langName = $mosConfig_lang;
        }
        if ( isset( $langCode[$langName] ) ) {
            return $langCode[$langName];
        }
        $sql = &quot;SELECT iso FROM #__languages WHERE active=1 AND code='$langName' ORDER BY ordering&quot;;
        $database-&gt;setQuery( $sql );
        $langCode[$langName] = $database-&gt;loadResult( false );
 
        return $langCode[$langName];
        // original code:
        // static $sLangName, $langCode;
        //
        // if (is_null($langName)) $langName = $mosConfig_lang;
        // if ($sLangName == $langName &amp;&amp; isset($langCode)) return $langCode;
        // $langCode = -1;
        // if ($langName != '') {
        //     $database-&gt;setQuery(&quot;SELECT iso FROM #__languages WHERE active=1 and code = '$langName' order by ordering&quot;Â«Â»);
        //     $langCode = $database-&gt;loadResult(false);
        // }
        // return $langCode;
// &lt;/mod&gt;-----------------------------------------------------------------------
    }
 
}