<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[FluxBB.org Forums - Database update question]]></title>
		<link>http://fluxbb.org/forums/topic/3050/database-update-question/</link>
		<description><![CDATA[The most recent posts in Database update question.]]></description>
		<lastBuildDate>Mon, 29 Jun 2009 15:06:45 +0000</lastBuildDate>
		<generator>FluxBB</generator>
		<item>
			<title><![CDATA[Re: Database update question]]></title>
			<link>http://fluxbb.org/forums/post/24002/#p24002</link>
			<description><![CDATA[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. :D

Thanks again. :)]]></description>
			<author><![CDATA[dummy@example.com (MattF)]]></author>
			<pubDate>Mon, 29 Jun 2009 15:06:45 +0000</pubDate>
			<guid>http://fluxbb.org/forums/post/24002/#p24002</guid>
		</item>
		<item>
			<title><![CDATA[Re: Database update question]]></title>
			<link>http://fluxbb.org/forums/post/23991/#p23991</link>
			<description><![CDATA[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.]]></description>
			<author><![CDATA[dummy@example.com (elbekko)]]></author>
			<pubDate>Mon, 29 Jun 2009 11:58:19 +0000</pubDate>
			<guid>http://fluxbb.org/forums/post/23991/#p23991</guid>
		</item>
		<item>
			<title><![CDATA[Re: Database update question]]></title>
			<link>http://fluxbb.org/forums/post/23988/#p23988</link>
			<description><![CDATA[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.]]></description>
			<author><![CDATA[dummy@example.com (Dave)]]></author>
			<pubDate>Mon, 29 Jun 2009 11:47:36 +0000</pubDate>
			<guid>http://fluxbb.org/forums/post/23988/#p23988</guid>
		</item>
		<item>
			<title><![CDATA[Database update question]]></title>
			<link>http://fluxbb.org/forums/post/23985/#p23985</link>
			<description><![CDATA[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?]]></description>
			<author><![CDATA[dummy@example.com (MattF)]]></author>
			<pubDate>Mon, 29 Jun 2009 10:07:29 +0000</pubDate>
			<guid>http://fluxbb.org/forums/post/23985/#p23985</guid>
		</item>
	</channel>
</rss>
