[pLog-svn] Database layout

[Jon Daley]

 	Are you able to fix the queries yourself?  If you have 
suggestions of how to fix them, feel free to post them, otherwise you have 
to wait for someone to get around to it.

On Mon, 22 May 2006, Ayalon wrote:
> Yes indeed, the problem is not the load etc on even huge sites. If a site 
> gets a lot of hits etc it can be so heavy if there are a lot of posts, 
> categories etc because of data loading which is not used anyway.
>
> Maybe it's better to do it like vbbulletin, in the admin you can enable or 
> disable some things for your user as a kind of server config. This way people 
> with performance problems, or problems with there host can immediately act.
>
> Anyway the categorie query needs to be adjusted not to scan the tables for 
> counts etc... Big queries should be divided in parts i think, this makes the 
> system more flexible and better to handle for all people in all enviroments 
> (and this is what we want no?!)