GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
alternateNames insert taking 1.5 days?  XML
Forum Index -> General
Author Message
[Post New]27/08/2010 00:42:08
    Subject: alternateNames insert taking 1.5 days?
[Up]
john_es



Joined: 26/08/2010 12:29:41
Messages: 15
Offline
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?

[Post New]21/10/2010 22:34:57
    Subject: Re:alternateNames insert taking 1.5 days?
[Up]
bg



Joined: 21/10/2010 22:29:49
Messages: 1
Offline
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.
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team