I love Vbulletin 4 allready do you ?

[raistlinthewiz]

I also liked the new vb4 publishing suite and on my sites i also code custom frontends. the problem is that i think vb4 cms's content handling at the backend side is a bit bloated. there is cms_article,cms_node and cms_nodeinfo.

To read a simple article from the db, 3 different queries on 3 different tables should run. i mean to get the latest articles:

• $query=$this->db->from('cms_node')->select('nodeid,contentid')->orderby('nodeid','DESC')->get();
• $query=$this->db->from('cms_nodeinfo')->select('title','viewcount','associatedthreadid' )->where('nodeid',$id)->get();
• $query=$this->db->from('cms_article')->select('contentid','pagetext','previewimage','ima gewidth','imageheight')->where('contentid',$id)->get();

i think this explains why cms runs a hundred queries for the front page,thanks to caching we don't feel that much but it's still a conceptual issue.