Developing CI Based Forum - WIP

[eluser]XMadMax[/eluser]
Hi srpurdy, seems that you are making a lot of joins whith forum_post, users and profile fields, with same where conditions.

Instead of making one big sql, why not retrieve forum_post data after first sql data is retrieved ?

If you make a select from 10 records, only this 10 records must to be completed with user/profile/count...

Example:

Query1 => result

Code:

foreach($result as $key => $val)
{
          QUERY User & profile data
          QUERY Totals and last post
}

Sometimes make 11 queries is better than only a big one. Think that mysql will cache this small queries, and many of those will be served from cache.