Hi. My question is similar to yours in some ways, perhaps we can help each other.
You say > We need no transactions, or any data integrity at all. We can afford to > loose some data in trade for performance. (like a few hours or something, > which seems like a lot even if the replication whould fail). If that's the case, why are you doing table locks at all? In most cases they won't be needed, and in the few cases where data might be overwritten, you can sacrifice that data for performance, no? Also why are you reconnecting? I think you can use mysql_pconnect() to create a connection pool and save the connection overhead. -- Steve Rapaport World Citizen --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
