> I didn't key the placename because they're not guaranteed to be
>unique, but that means that a search for "Artesia" takes many (~30)
>seconds to complete, which is really not very useful.
You should not use the placename as a PRIMARY KEY, but it can still have
an index. You really should add a
Hi, all,
I'm still very much a newbie at MySQL, and thought a good starter project
would be a simple places database of every populated place-name in the world
along with its latitude and longitude. I already have the data, and
originally planned to have only 4 tables with 2-4 fields each:
Pla
