Query Optimization

[Keloran]

Im wondering when vBulletin will be optimizing its querys, i see a worrying amount of <table>.* querys, or SELECT COUNT(*)

why are there so many of these, its madness and wastes processing, if i add a plugin that adds another field to the posts table for example, then doing SELECT * is pulling that info too

what should be done is, e.g.

SELECT COUNT(postid) as postcount FROM post WHERE threadid = <threadid>

NOT

SELECT COUNT(*) as postcount FROM post WHERE threadid = <threadid>

that is just stupid, in the next version of vB (vB4) will all these problems be sorted, it would also mean, after correct index's the processing/memory requirements of vB would fall dramaticlly