Re: [Phpwebsite-developers] Key documentation written (badly)

[Shaun M. <sh...@ae...>]

On 2 May 2006, at 21:52, Matthew McNaney wrote:
>
> Understand rewriting key is a major undertaking so I must be positive
> the delay would be worth it.
>

I'll second Eloi's call for separate key tables for each module.

Most modules won't be a problem but there's one specific module which  
needs all the help it can get and that's ANY forum module.  
Potentially you've got millions of posts in a forum. Inefficient  
queries and searches can bring a site to it's knees. Keeping the  
queries as efficient as possible and using the indexes is very  
important.

While I'm on searches. If you're re-doing searching, a time limited  
search would be useful so that, by default at least, a user isn't  
searching every single item ever published on a site. I found that on  
a site with 3-4 years of cruft, and a few hundred thousand forum  
posts, just setting the default for a search to 'the last 30 days'  
instead of 'since the dawn of time' resulted in a load less resources  
being used. A little bit of social engineering goes a long way to  
make up for cheap-ass servers (not that I have any of those now) or  
bad code.


Shaun
aegis design - http://www.aegisdesign.co.uk
aegis hosting - http://www.aegishosting.co.uk