Unfortunately no one can be told what FluxBB is - you have to see it for yourself.
You are not logged in. Please login or register.
FluxBB.org Forums » Programming » Database update question
Just wanting to double check on this one. 
In theory, is best to see if an entry matches certain criteria in a specific table before applying an UPDATE to change the value, or just do the UPDATE incase any rows match the criteria, without checking first?
I assume the second method, as there's one less query to the DB?
Screw the chavs and God save the Queen!
Depends really. There are, potentially, situations where you would want to only update things that have changed and other cases where simply updating everything might be a better choice. I don't think you can say that either method is THE method to use.
Dave
Well, the general consesus is usually 'let the database handle it', especially for constraints etc.
I'd go for the second case, you can always see if any rows were affected, so that isn't a reason to not do it this way either.
Ben
SVN repository for my extensions - The thread
Quickmarks 0.5
“Question: How does a large software project get to be one year late? Answer: One day at a time!” - Fred Brooks
Cheers chaps. It's only a straight forward update for a forum id if the topic reference id exists, so whether it exists isn't the important part, merely the changing of it if it does. Didn't want to be using the second method if had any known caveats though. 
Thanks again.
Screw the chavs and God save the Queen!
FluxBB.org Forums » Programming » Database update question
Powered by FluxBB