Follow us on Twitter
Collapse
Welcome, Guest
Please Login or Register.    Lost Password?
JoomAce Support
AceSEF
General Support

Page Load extremely slow
(3 viewing) Engin Yilmaz, Paweł Wróbel, (1) Guest
Go to bottomPage: 123
TOPIC: Page Load extremely slow
#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
No photo available
VIP Customer

Posts: 22 - Posts: 22 - Forums Func View Catid

Support Forums includes Forums Section View Category 53 Id 7031

graphgraph
Click here to see the profile of this user
The administrator has disabled public write access.
 
#13542
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
No photo available
VIP Customer
Posts: 22
graphgraph
Click here to see the profile of this user
The administrator has disabled public write access.
 
#13546
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
No photo available
VIP Customer
Posts: 22
graphgraph
Click here to see the profile of this user
The administrator has disabled public write access.
 
#13547
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
No photo available
VIP Customer
Posts: 22
graphgraph
Click here to see the profile of this user
The administrator has disabled public write access.
 
#13553
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
Forum avatar
Administrator
Administrator rank
Posts: 2386
graph
Click here to see the profile of this user
Gender: Male
Ratings/Reviews on the Joomla Extension Directory are always appreciated.
The administrator has disabled public write access.
 
#13558
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
rnrnrn//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
rnrn rn rn rn
rn div>rn rn
rn
rnrn rn rn  rn  rn
rn
rn rn div>rn rn rn
rn rn rn
rn
rnrn rn rn          Salirrn rn
rnrn rn rn rn
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
No photo available
VIP Customer
Posts: 22
graphgraph
Click here to see the profile of this user
Last Edit: 2010/10/14 05:46 By Hermes.
The administrator has disabled public write access.
 
#13559
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
Forum avatar
Administrator
Administrator rank
Posts: 2386
graph
Click here to see the profile of this user
Gender: Male
Ratings/Reviews on the Joomla Extension Directory are always appreciated.
The administrator has disabled public write access.
 
#13561
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
No photo available
VIP Customer
Posts: 22
graphgraph
Click here to see the profile of this user
The administrator has disabled public write access.
 
#13575
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
No photo available
VIP Customer
Posts: 22
graphgraph
Click here to see the profile of this user
The administrator has disabled public write access.
 
#13584
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
Forum avatar
Administrator
Administrator rank
Posts: 2386
graph
Click here to see the profile of this user
Gender: Male
Ratings/Reviews on the Joomla Extension Directory are always appreciated.
The administrator has disabled public write access.
 
Go to topPage: 123
JoomAce Support
AceSEF
General Support
Powered by Kunenaget the latest posts directly to your desktop