[Jaxel]

Originally Posted by TCB

How come this mod uses so many queries?

video.php?do=viewcategory&categoryid=10 (1 video) takes 9 queries
video.php?do=viewcategory&categoryid=12 (17 videos) takes 25 queries (!?)

you'd think the amount of shown videos in a category would be 'query independant'? For example: when I set the amount of videos to be shown in the vbadvance video directory module from 3 to (for example) 6 videos, it has no influence on the amount of queries for that page. Shouldn't it be cached or something?

When many people browse through the video directory at a particular moment, it really stresses the server.

The extra query for each video has to do with the taglist. For each video bit, it has to query the tags on that video. The amoutn of shown videos in the category, IS query independant. However, the scan for tags for each video is not; the amount of tags on each video however, is query independant as well. The reason why this extra query per video is not in the vbadvanced/forumhome mod is because they dont query the tags.