Page takes forever to load

[sdawkins]

I am hoping there is something I can do to fix the speed of the Suggest Link page. It takes an eternity to load. I have quite a few Categories, but I think I have seen other sites that have a lot too.

I know there is something you can add to the php file that helps cut down the time, but I do not seem to still have the code for it.

Could this problem also be a result of the drop down box not showing correctly as posted in another thread?

The site is http://www.bestpetdirectory.com

Thanks.

[sdawkins]

I found this, but when I tried to add it but got an error....

<?php
ob_start( 'ob_gzhandler' );
?>

[sdawkins]

I just looked at my database and was wondering if this could be the problem...

The dir_categories show 707 but that is incorrect (off by about 20)
the dir_flat_structure shows 7726
the dir_links shows 3758

Could this be because of the conversion from PHPLD maybe?

[Sergey Ten]

Hi, sdawkins

Seems, this problem in the table flat_structure. You necessary to remove all data in your table flat_structure and I will email you the file which will help you build new table flat_structure. Please post your email.

I just looked at my database and was wondering if this could be the problem...

The dir_categories show 707 but that is incorrect (off by about 20)
the dir_flat_structure shows 7726
the dir_links shows 3758

Could this be because of the conversion from PHPLD maybe?

[sdawkins]

Thank you.
Email address: shadey33 @ comcast.net (remove spaces)

[Sergey Ten]

Ok, I sent.

Thank you.
Email address: shadey33 @ comcast.net (remove spaces)

[sdawkins]

Ok, I sent.


Sergey,

No attachment with email. I sent you an email with info.

Thank you.

[Sergey Ten]

sdawkins

Please email me your FTP credentials

sten@esyndicat.com

[sdawkins]

Hi Sergey,

Did that :)

[sdawkins]

Thank you Sergey Ten for fixing the table flat_structure.

Page still loads very slow though :cry:

[Sergey Ten]

2 sdawkins

I will tell Simon about your problem and he will try to answer you.

[sdawkins]

2 sdawkins

I will tell Simon about your problem and he will try to answer you.

Thank you. Hopefully it can be worked out somehow :)

[Sergey Ten]

2 sdawkins

I will tell Simon about your problem and he will try to answer you.

Thank you. Hopefully it can be worked out somehow :)

I hope too ;)

[gb]

for me your pages load very fast. did you change something? I would like to know as my pages take about 5-10 seconds to generate...

[Vasily B.]

there is one possible way to fix your problem. go to your phpMyAdmin and create an index for the following field of your link_categories table:
id_category. Or simply run the following query:
ALTER TABLE `dir_link_categories` ADD INDEX ( `id_category` )
Use correct prefix

[gb]

thanks simon. 0,7 seconds generation time compared to 28 seconds before ;-)

[Vasily B.]

you are welcome ;)

[Cris Santos]

i followed Simon's instructions in phpmyadmin and nothing happened. Still takes forever to enter "Suggest-Link" and most times it just crashes.
Please advise.
I now only have 5000 or so cats...

[sdawkins]

Even though things got quicker with what Simon did, and with the gzip it was still taking too long. I just changed disabled this instead "Categories dropdown instead of tree" for now.