|
May i suggest using another database system instead of MySQL?, something perhaps a bit more optimised for large usage.
As for search queries, why not reduce them to 30 seconds?
perhaps it may be worthwhile offering a google search feature instead - which would be useful if google has spidered your site recently. It may not be as up to date, however it would indeed alleviate the strain from your servers.
|