performance tips:
If you have made efforts to boost the performance by optimizing your queries and your application code, there are number of server-level and language-level tunings for high-traffic websites (OS, MySQL, hardware related) that you (or your host admin) can try to ensure that an application performs at its best.

*Use the latest stable MySQL version. There are enough things that run faster on MySQL 4.x and later versions (improved SQL query optimizer behaviour, query cache if enabled, SQL_CALC_FOUND_ROWS option, full-text indexing, more efficient SQL syntax in some cases, etc.,

thanks,
venkatbi