Hi Greg, This may be rubbish, but you could ruin a cron process (perhaps daily) to:
create table newstats as select * from livestats; then create the indexes then have the clients query the newstats table (moving the load away from your live table) You may also want to look at what table types you're using (MyISAM uses table level locking by default) http://www.sitepoint.com/blogs/2009/09/08/free-performance-with-mysql-table-types/ Paul --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
