FluxBB Forums / Database update question

Re: Database update question

dummy@example.com (MattF) — Mon, 29 Jun 2009 15:06:45 +0000

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.

Re: Database update question

dummy@example.com (elbekko) — Mon, 29 Jun 2009 11:58:19 +0000

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.

Re: Database update question

dummy@example.com (Dave) — Mon, 29 Jun 2009 11:47:36 +0000

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.

Database update question

dummy@example.com (MattF) — Mon, 29 Jun 2009 10:07:29 +0000

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?