Developing CI Based Forum - WIP

[eluser]srpurdy[/eluser]
http://imageshack.us/photo/my-images/7/m...splay.jpg/

http://imageshack.us/photo/my-images/36/...eries.jpg/

Posting a couple more pictures. This is showing the main forum display, and the second picture is the query display. For this example we render the entire main display in 16 queries. Although this would vary depending on how many categories you would have. I thought about putting all the result sets for that into an array also, but decided probably it's unlikely that it would be a problem to have 1 query per category for the entire display. I think that's fine. Thoughts?

In anycase the subforums, and user permissions are extracted via array's so there is no query stacking. So if you have 1 category and 500 forums it will still only do a total of 5 queries. (3 global) and 1 for the category and 1 for all of the 500 forums. Same is true if you only have 1 category and 1 forum. So there is 1 extra query per category. This is the only stacking at the moment. Since most forums don't have too many of these. I think most I've seen is 10. I don't imagine that being an issue. Although wouldn't mind some feedback on that if people think it would be a problem.