You could try partitioning the table into 2 or more tables e.g., one table holds all the odd listing_id rows and one holds all the even ones. Kind of a delaying tactic really. I've found mysqlperformanceblog.com helpful at times.
Rory --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
