<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Monthly syncronization "]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Monthly syncronization "]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Monthly syncronization </title>
				<description><![CDATA[ Hi marc,

I would be nice with an incremental synchronization file in addition to the daily syncronization files. Would you be able create e.g. incremental file from e.g. jan 1 2009, which will always hold the latest updates, and let this file be there for the whole year?

The reason why I am asking is that we typically don't update everyday. So if we want updates then we have to download the entire database again. It would save you some bandwith costs.

Let me know what you think.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1258.page#5390</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1258.page#5390</link>
				<pubDate><![CDATA[Mon, 9 Feb 2009 22:01:27]]> GMT</pubDate>
				<author><![CDATA[ perels]]></author>
			</item>
			<item>
				<title>Re:Monthly syncronization </title>
				<description><![CDATA[ If someone wants to update to the newest data once per year only then it is better to use the full dump instead of the incremental dump. Some occasional updates are done directly on the database and don't make it into the modification files. 

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1258.page#5392</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1258.page#5392</link>
				<pubDate><![CDATA[Tue, 10 Feb 2009 07:51:59]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Monthly syncronization </title>
				<description><![CDATA[ Hi Marc, 

Thanks for replying. I did not mean update once a year, but less regularly than daily. I would be great with a rollup file for each of the months. 
E.g. one for january, february, march - always 3 months back in time...

I am using sql-server and it is a pain in the neck, to import the whole package, apply the updates and delete the unwanted. 

Would it be easy to just run something like the following pseudo-code;

select * from geonames where lastupdate = current month - 1

on the 1. of each month and save this in a txt file a?

Just a thought - hope you will consider it because it would really save some time ;-)]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1258.page#5411</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1258.page#5411</link>
				<pubDate><![CDATA[Fri, 13 Feb 2009 04:30:15]]> GMT</pubDate>
				<author><![CDATA[ perels]]></author>
			</item>
			<item>
				<title>Re:Monthly syncronization </title>
				<description><![CDATA[ Actually, I think the feature could be done totally outside of geonames.
It would be pretty easy (but kinda boring..) to take 2 dumps, import them to different db/tables, and then create a diff between the two.

and the diff could be used to update production servers once every X days/weeks/months.
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1258.page#5417</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1258.page#5417</link>
				<pubDate><![CDATA[Sat, 14 Feb 2009 04:46:58]]> GMT</pubDate>
				<author><![CDATA[ samokk]]></author>
			</item>
			<item>
				<title>Monthly syncronization </title>
				<description><![CDATA[ Hi samokk / marc, 

This is actually what we do now - and each time this will  take around a 3 hours before completion.
- Download is around 5-10 min.
- Import will take around 30 minutes using BULK INSERT
- update/diff script completes in 2.5 hours.

Hope you will consider this seriously so that we could get more sparetime and less wasted time ;-)]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1258.page#5419</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1258.page#5419</link>
				<pubDate><![CDATA[Mon, 16 Feb 2009 01:23:20]]> GMT</pubDate>
				<author><![CDATA[ perels]]></author>
			</item>
			<item>
				<title>Re:Monthly syncronization </title>
				<description><![CDATA[ You could look at the modification date field and filter the records that have been updated since your last synchronization. This would be considerably faster but not as thorough as reloading the entire database from scratch 

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1258.page#5426</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1258.page#5426</link>
				<pubDate><![CDATA[Mon, 16 Feb 2009 22:31:50]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>