By dnguyen on

On my front page, I want to use a block representing a view that grabs the most recent frontpage promoted node. I read somewhere (I think it was Team Sugar's writeup for their site) that for some parts of their frontpage, they wrote their own SQL because Views just hammered their database. Is my example going to cause a noticeable problem?

One other factor: this particular content type has a node reference that refers to an Author type node. So I run a node_load to get the author's title. Something like this:

    if(isset ($field_authors[0][nid])){
         $author = node_load($field_authors[0][nid]);
    }
    print "<br /><b>Author:</b> " . l($author->title, 'node/' .$author->nid);
⋅ Categories: Drupal 5.x

Comments

inforeto’s picture

inforeto commented

Probably not, just keep in mind that the frontpage is the most viewed page.
Views can get slow only when it loads too much data, like with multiple cck fields.
The node_load function is also useful because it pulls cached data.
You can even combine node_load with views to avoid the said issue with too many cck fields.