<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "alternateNames insert taking 1.5 days?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "alternateNames insert taking 1.5 days?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>alternateNames insert taking 1.5 days?</title>
				<description><![CDATA[ LOAD DATA INFILE alternateNames.txt' INTO TABLE alternatename (alternatenameid,geonameid,isoLanguage,alternateName,isPreferredName,isShortName);

The allcountries db inserted in less than 30 mins, but the alternate names table is taking amazingly forever.

Has anyone else experiences this?

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2055.page#8331</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2055.page#8331</link>
				<pubDate><![CDATA[Fri, 27 Aug 2010 00:42:08]]> GMT</pubDate>
				<author><![CDATA[ john_es]]></author>
			</item>
			<item>
				<title>Re:alternateNames insert taking 1.5 days?</title>
				<description><![CDATA[ I had a similar issue the first time I tried the import.

The second time it only took ~20 minutes.  The differences:
1. Imported alternateNames before allCountries
2. Changed the tables from InnoDB to MyISAM
3. Added UNIQUE INDEX for the ID value


Now, as to which of these (if any) fixed the problem, I have no idea.
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2055.page#8614</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2055.page#8614</link>
				<pubDate><![CDATA[Thu, 21 Oct 2010 22:34:57]]> GMT</pubDate>
				<author><![CDATA[ bg]]></author>
			</item>
	</channel>
</rss>