GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
index creation time  XML
Forum Index -> General
Author Message
[Post New]10/12/2007 13:31:06
    Subject: index creation time
[Up]
jlsanmiguel



Joined: 10/12/2007 13:27:54
Messages: 1
Offline
Hi all, I have imported the geonames table into my database and now I'm tring to create an index for the "name" so I have run:

CREATE INDEX name ON geonames (name)

about 20 minuts ago, my question is:

this is the correct way to do it? how long it takes?(I have a fast machine)
cause I don't know if its blocked or still running (Its using CPU anyway)

cheers
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team