Hello, I have a few sites on Joomla + OpenSEF working fine! But the oldest of them have serious problems related to OpenSEF: It seems that it is generating lots of sorting queries! When i run "mysqladmin pr" command i see the following result: | 5776 | levent_levent | localhost | levent_xx | Query | 0 | Sorting result | SELECT * FROM javatips_sef WHERE 1 AND (direction IS NULL OR direction = '' OR direction = 'o') AND | | 5793 | levent_levent | localhost | levent_xx | Query | 7 | Sorting result | SELECT * FROM javatips_sef WHERE 1 AND (direction IS NULL OR direction = '' OR direction = 'o') AND | | 5814 | levent_levent | localhost | levent_xx | Query | 7 | Sorting result | SELECT * FROM javatips_sef WHERE 1 AND (direction IS NULL OR direction = '' OR direction = 'o') Code (markup): Upgrading OpenSEF generated url-rewrite loop! Even if i removed entries from OpenSEF table and run a crawler to obtain the friendly urls from the start, it again generated url-rewrite loop which make my web server unresponsive. Now, i am thinking to cnage my CMS by keeping friendly urls as much as i can. What do you suggest? What can be the problem?
do not upgrade . uninstall opensef and reinstall newset opensef version. i think this will solve your problem
That was what i did. Skipping them but after some point i started to see huge performance problems. If i will not lose my url in google, then this solution seems to work perfectly. We tried that way too. In fact we upgraded joomla, reinstall opensef (by removing table data too)and run a crawler to regenerate the urls again. Unfortunately, after a few days, my server gave url-rewrite loops again. Now cpu usage is below %30 geenrally... 404sef is better but i am trying to be careful with my old urls too