Display recent posts on external vb page

[boske]

I just put together a select from the database, here is what it looks like:

PHP Code:

 $result = mysql_query("SELECT * FROM vb3_thread WHERE forumid != 23 ORDER BY lastpost DESC LIMIT 0,10");


while($r=mysql_fetch_array($result)){

$threadid=$r["threadid"];
$title=$r["title"];
$postusername=$r["postusername"];
$forumid=$r["forumid"];
$replycount=$r["replycount"];
$posterid=$r["postuserid"];
$views=$r["views"];


?>
<tr align="middle">
            <td class="alt2" align="left"><a href="http://www.example.com/forums/showthread.php?t=<? echo $threadid; ?>"><? echo $title; ?></a></td>
            <td class="alt1Active" id="f44" align="center"><? echo $replycount; ?></td>
            <td class="alt2" noWrap width="32"><? echo $views; ?></td>
            <td class="alt1"><a href="http://www.example.com/forums/member.php?u=<? echo $posterid ?>"><? echo $postusername; ?></a></td>
        </tr>
<?
}
?>

The problem is, it takes about 3-4 seconds to load those 10 posts, when its faster to load the whole vb website...

Any suggestions?

Steve

[boske]

_________________
well I kind of figured out why it was slow...anways I setup a cron job to run the file because I think the query was just way to big, so the cron job will run a file with all the stuff I would like to query, and then I setup another script the query a smaller database with the stuff I need...

Result: Instant feed...