A Page on the site is very slow

Posted by ashoksharma on January 26, 2012 at 7:12pm

I have a page on my site that is very slow and takes a lot of time to load because it fetches data from external websites. I have installed boost on the site and enabled catching but there is not any improvement.
you can check the page - http://www.seoabc.in/resources/social-bookmarking-sites-list

Is there any way I can improve it?

Thanks

Comments

Slow doesn't even cover it :)

Posted by nevets on January 26, 2012 at 7:24pm

Slow doesn't even cover it :) I am guessing you are fetching the data in real time, in which case I would fetch the data periodically using hook_cron() and display the already fetched data.

Hello, Can you please give me

Posted by ashoksharma on January 26, 2012 at 8:31pm

Hello,
Can you please give me a little more details as I am new with PHP?
Or give me a link where it is exactly described..

I created a new table in the database and displaying data on the page by fetching it from database table.

Thanks for your reply

Engineers Garage | 8051 Projects | SEO ABC | Social Bookmarking

My code is something like

Posted by ashoksharma on January 27, 2012 at 8:17pm

My code is something like this

<?php

    $sql = "select * FROM bookmarkingsites";

    $qury = mysql_query($sql);
$num = 1;
    while($row = mysql_fetch_array($qury))
    {
    ?>
		<tr align="left" height="30px">
			<td>
#<?php echo $num;?>			</td>
			<td>
<a href="<?php echo $row[3];?>"><?php echo $row[2];?></a>		</td>
			<td>
            <?php echo $row[4];?>
				</td>

would you please give me an idea where to use hook_cron() ?

Engineers Garage | 8051 Projects | SEO ABC | Social Bookmarking

Ignore the cron comment, the

Posted by nevets on January 27, 2012 at 8:36pm

Ignore the cron comment, the time the is completely local. Is that code in a node or a module? If you create a module with a callback the page should be cached. The slowness is from the length of the list, long lists are generally paginated.