|
Page Load extremely slow 2 Months ago
|
|
|
Hi Denis!
I hope you can help me as in previous times...
I'm trying to use AceSef in one of my old sites, after upgrading it to the new version of joomla.
The site works OK, even If I use Joomla SEF the site works OK.
I'm using virtuemart & zoo components in this site, and obviously joomla redirect doesn't work with joomla SEF.
After installing AceSef with no problem all the site works extremely slow. I'm talking about 8-9 seconds per page, when before
it use to be 1-2 seconds.
I tried to use all the tricks you described in this post: www.joomace.net/support/forums?task=topi...=1&id=6341#p6450
But nothing works for me, and the load time is very slow.
Upps! I forgot to comment you that I took a look to my htaccess and is correct, and equal to the htaccess I use in my other sites that work OK with AceSef.
I don't know exactly what to do in the configuration od AceSef to get the correct load times.
¿Any Idea?
Thanks!!
|
|
Alberto Quintero Cano
VIP Customer
Posts: 22 - Posts: 22 - Forums Func View CatidSupport Forums includes Forums Section View Category 53 Id 7031
|
|
|
|
|
Page Load extremely slow 2 Months ago
|
|
|
Hi Denis!
I hope you can help me as in previous times...
I'm trying to use AceSef in one of my old sites, after upgrading it to the new version of joomla.
The site works OK, even If I use Joomla SEF the site works OK.
I'm using virtuemart & zoo components in this site, and obviously joomla redirect doesn't work with joomla SEF.
After installing AceSef with no problem all the site works extremely slow. I'm talking about 8-9 seconds per page, when before
it use to be 1-2 seconds.
I tried to use all the tricks you described in this post: www.joomace.net/support/forums?task=topi...=1&id=6341#p6450
But nothing works for me, and the load time is very slow.
Upps! I forgot to comment you that I took a look to my htaccess and is correct, and equal to the htaccess I use in my other sites that work OK with AceSef.
I don't know exactly what to do in the configuration od AceSef to get the correct load times.
¿Any Idea?
Thanks!!
|
|
Alberto Quintero Cano
VIP Customer
Posts: 22
|
|
|
|
|
Page Load extremely slow 2 Months ago
|
|
|
I've been trying different things without success.
I will continue testing but....
¿Any Idea?
|
|
Alberto Quintero Cano
VIP Customer
Posts: 22
|
|
|
|
|
Page Load extremely slow 2 Months ago
|
|
|
I'm so sorry, but I don't find the way to make work my site as fast as with joomla sef.
The page load is incredible slow with AceSef, and I don't know why.
¿Could you help me?
Thanks!!
|
|
Alberto Quintero Cano
VIP Customer
Posts: 22
|
|
|
|
|
Page Load extremely slow 1 Month, 4 Weeks ago
|
|
|
It sounds like something revalent with your second site but I can't say anything without observing your site so can you plz provide us a super admin account via our Tickets System.
|
|
Denis Dulici
Administrator
Posts: 2386
|
|
Ratings/Reviews on the Joomla Extension Directory are always appreciated.
|
|
|
Page Load extremely slow 1 Month, 4 Weeks ago
|
|
First, thanks for your fast answer considering that everyone are on holydays.
I have created an superadmin account for you, anyway, I think that I have finally found what's going wrong.
Actually, I've found when I was trying to make a backup of the database.
I've found, I think, the same possible error in two of my sites that use AceSef, and this error is located in the table "prefix_acesef_urls".
I'm not sure if this is really an error, but the "acesef_urls" table weights in one site 16.5 mbytes,
and in the site I told you that the page load is very slow weights 35.6 mbytes.
¿Is this a normal weight for this table?
I think Nooo!!
Well, I hope no, of course, because I want to make regulary backups of the database by email,
and this weight overstep the weight accepted by my email program.
Direct to the point....
The possible fail is in the field 'sm_date'.
I don't know why but when AceSef collect all the info for redirect each link,
in the case of some -ZOO Links- & -VIRTUEMART Links-
this field 'sm_date' is filled with all the HTML of each redirected page.
And this is the reason that database weights no less than 35Mbytes.
And I think that this is the reason that my site was Extremely Slow after activate AceSef,
because the system must find results into a table of 35 Mbytes.
Weird! isn't it?
To understand better, I think is more clear to paste a piece of sql code of any of the sites:
| Code: |
DROP TABLE IF EXISTS `jos_acesef_urls`;
CREATE TABLE IF NOT EXISTS `jos_acesef_urls` (
`id` int(10) unsigned NOT NULL auto_increment,
`url_sef` varchar(255) NOT NULL default '',
`url_real` varchar(255) NOT NULL default '',
`metatitle` varchar(255) default '',
`metadesc` varchar(255) default '',
`metakey` varchar(255) default '',
`metalang` varchar(30) default '',
`metarobots` varchar(30) default '',
`metagoogle` varchar(30) default '',
`linkcanonical` varchar(255) default '',
`published` tinyint(1) unsigned NOT NULL default '1',
`used` tinyint(1) unsigned NOT NULL default '5',
`locked` tinyint(1) unsigned NOT NULL default '0',
`blocked` tinyint(1) unsigned NOT NULL default '0',
`notes` text,
`sef_tmp_url` varchar(255) NOT NULL default '',
`checked_out` int(11) NOT NULL,
`date` date NOT NULL default '0000-00-00',
`source` text,
`sm_indexed` varchar(3) NOT NULL default '',
`sm_date` date NOT NULL default '0000-00-00',
`sm_freq` varchar(30) NOT NULL default '',
`sm_priority` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `url_real` (`url_real`),
KEY `url_sef` (`url_sef`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2653 ;
INSERT INTO `jos_acesef_urls` (`id`, `url_sef`, `url_real`, `metatitle`, `metadesc`, `metakey`, `metalang`, `metarobots`, `metagoogle`, `linkcanonical`, `published`, `used`, `locked`, `blocked`, `notes`, `sef_tmp_url`, `checked_out`, `date`, `source`
, `sm_indexed`, `sm_date`, `sm_freq`, `sm_priority`) VALUES
(1, 'bienvenido-a-ilifewave.html', 'index.php?option=com_zoo&item_id=3&view=item', 'Bienvenido a iLifewave!', 'David Schmidt para la lucha contra el dolor, aumentar la energ??
a, mejorar el descanso, eliminar las arrugas, controlar el apetito y para la regener', 'lifewave, life wave, david schmidt, parches lifewave, negocio lifewave, parches dolor, parches energ??
a, parches dormir, sp6, parches control del apetito, parches para adelgazar, parches antiarrugas', '', '', '', '', 1, 10, 1, 0, NULL, '', 0, '0000-00-00', 'JRoute->_(''index.php?option=com_zoo&task=item&item_id=3'')--b2--/administrator/components/
com_zoo/elements/itemname/itemname.php--b2--60n--b1--nElementItemName->render(Array)--b2--/components/com_zoo/renderer/element/default.php--b2--21n--b1--ninclude(''/home/ilifewav/public_html/components/com_zoo/renderer/element/default.php'')--b2--/
administrator/components/com_zoo/framework/renderer.php--b2--55n--b1--n', '1', '2010-07-22', 'daily', '0.5'),
|
(Since here all works OK)
But suddenly in the VALUE 35 AceSef write again INSERT INTO........
And start to have the behaviour that I told you... to insert the entire HTML code in the registers of the table.
See the following Code
| Code: |
INSERT INTO `jos_acesef_urls` (`id`, `url_sef`, `url_real`, `metatitle`, `metadesc`, `metakey`, `metalang`, `metarobots`, `metagoogle`, `linkcanonical`, `published`, `used`, `locked`, `blocked`, `notes`, `sef_tmp_url`, `checked_out`, `date`, `source`
, `sm_indexed`, `sm_date`, `sm_freq`, `sm_priority`) VALUES
(35, 'blog', 'index.php?option=com_zoo&category_id=2&view=category', 'Blog', 'David Schmidt para la lucha contra el dolor, aumentar la energ??
a, mejorar el descanso, eliminar las arrugas, controlar el apetito y para la regener', 'lifewave, life wave, david schmidt, parches lifewave, negocio lifewave, parches dolor, parches energ??
a, parches dormir, sp6, parches control del apetito, parches para adelgazar, parches antiarrugas', '', '', '', '', 1, 10, 1, 0, NULL, '', 0, '0000-00-00', 'JRoute->_(''index.php?option=com_zoo&task=category&category_id=2'')--b2--/plugins/system/
sef.php--b2--121n--b1--nplgSystemSef->route(Array)--b2--n/a--b2--n--b1--npreg_replace_callback(''#href="/index.php?([^"]*)#m'', Array, ''html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
transitional.dtd">rnrnrn n n n n n n n n n n n n iLifewave - Bienvenidos a iLifeWave! - iLifewaven n n n n n n n n n n n n n n nvar YtSettings = { tplurl: ''/
templates/yoo_studio'', color: ''blue'' };n n n .s5boxhidden{display:none;}
style>n var s5_boxeffect = "elastic";n n n n n jQuery(document).ready(function(){ jQuery(".s5box_one").colorbox({width:"28%", inline:true, href:"#s5box_one"});jQuery(".s5box_two")
.colorbox({width:"53%", inline:true, href:"#s5box_two"});jQuery(".s5box_three").colorbox({width:"35%", inline:true, href:"#s5box_three"});jQuery(".s5box_four").colorbox({width:"35%", inline:true, href:"#s5box_four"});jQuery(".s5box_five")
.colorbox({width:"35%", inline:true, href:"#s5box_five"});jQuery(".s5box_six").colorbox({width:"35%", inline:true, href:"#s5box_six"});jQuery(".s5box_seven").colorbox({width:"35%", inline:true, href:"#s5box_seven"});jQuery(".s5box_eight")
.colorbox({width:"35%", inline:true, href:"#s5box_eight"});jQuery(".s5box_nine").colorbox({width:"35%", inline:true, href:"#s5box_nine"});jQuery(".s5box_ten").colorbox({width:"35%", inline:true, href:"#s5box_ten"});});nrnrnrnrnShadowbox.init();rnrn rnrnrnrnrnrn rn rnDebes tener activado javascript para el correcto funcionamiento del sitio.rnPor favor, act??valo y refresca la p?°gina.rn rnrn rn//rnrn var mod_yooholiday_path = "http://www.ilifewave.es/modules/mod_yoo_holidays/";rnrnrnrn
div>rn rn rn rn rn rn rn rn rn rn rn rn Jueves 22 de Julio de 2010 rn rn rn rn rn
div>rn rn rn rnrn rn rn rn rn rn rn rn
div>rn rn rn rn rn rn rn rn rn rn rn rnrnrnrn rn rn rn rn rn rn rn rn rn...........................
|
And this behaviour keep on until the creation of the last link.
¿Is this behaviour normal?
Remember that his problem only happen in the case of ZOO links or VIRTUEMART Links
¿Are working AceSef as expected?
Well, I'm going to send you by Ticket System the superadmin account I created for you, although I think that the problem couldn't be my system, or modules, or plugings installed, but AceSef ZOO & Virtuemart Extensions, ¿Am I wrong?
Nothing More!
Thank you again for your answer, and I believe you can search as fast as possible the problem and solve them.
These two sites are in production, and one of them is being indexed without you Marvelous AceSef Extension.
Bye!!
|
|
Alberto Quintero Cano
VIP Customer
Posts: 22
|
|
Last Edit: 2010/10/14 05:46 By Hermes.
|
|
|
Page Load extremely slow 1 Month, 4 Weeks ago
|
|
|
OK, that's clear, the issue consist on the "source" field, not "sm_date". Go to AceSEF=>Configuration=>Advanced=>Enable Source Tracker and set it to "No" then purge URLs.
|
|
Denis Dulici
Administrator
Posts: 2386
|
|
Ratings/Reviews on the Joomla Extension Directory are always appreciated.
|
|
|
Page Load extremely slow 1 Month, 4 Weeks ago
|
|
|
Well, now the database seems to be created OK. Now, prefix_acesef_urls weights 106kbytes with 335 links created.
But, unfortunately, my site keep on being slow after activate AceSef.
I'm very tired and confused.
I thought I had found the problem, and now it's seems that this wasn't the problem.
Buaaaah! Buaaaah! (I'm crying with despair)
Just kidding!
¿Any Idea?
I just sent you the superadmin account you asked me.
¿Could you take a look?
|
|
Alberto Quintero Cano
VIP Customer
Posts: 22
|
|
|
|
|
Page Load extremely slow 1 Month, 3 Weeks ago
|
|
|
Hello Denis,
I'm sorry, but I have not found any solution for my problem yet.
Did you get the super admin account I sent you via service tickets?
Could you take a look and offer me some help about the page load?
Thank You in advance?
|
|
Alberto Quintero Cano
VIP Customer
Posts: 22
|
|
|
|
|
Page Load extremely slow 1 Month, 3 Weeks ago
|
|
|
I just checked your site and the load is not normal, I realized that you've some custom lines in .htaccess file, get a clean htaccess.txt from a Joomla installation package and try it plz.
|
|
Denis Dulici
Administrator
Posts: 2386
|
|
Ratings/Reviews on the Joomla Extension Directory are always appreciated.
|
|
|