By ashoksharma on

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

⋅ Categories: Drupal 6.x

Comments

nevets’s picture

nevets commented

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.

ashoksharma’s picture

ashoksharma commented

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

ashoksharma’s picture

ashoksharma commented

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() ?

nevets’s picture

nevets commented

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.