Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies


7:02 pm on Nov 2, 2010 (gmt 0)

10+ Year Member

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.

UPDATE `counter` SET main_counter = main_counter + 1

SELECT `main_counter` FROM `counter`
8:55 pm on Nov 2, 2010 (gmt 0)

WebmasterWorld Senior Member demaestro is a WebmasterWorld Top Contributor of All Time 10+ Year Member

You can do it in a transaction...

the syntax depends on what db/version you are using.

Check the user guide of your db for TRANSACTION

Featured Threads

Hot Threads This Week

Hot Threads This Month