Msg#: 4225593 posted 7:02 pm on Nov 2, 2010 (gmt 0)
My site has a simple counter. there are two queries that run back to back. Is there any way to join these into one query? Even if it just reduced the number of database connections, this page gets loaded a lot, any little optimization will be magnified a lot.
1) UPDATE `counter` SET main_counter = main_counter + 1