GeoNames Forum

Hi --

It seems like the web service for doing wikipedia searches has slowed down. I'm not complaining -- hey it's free! -- but it seems like it was faster when I first started using it. Has anyone else noticed this?

The server seems to take around 20 seconds for a query. Is that normal?

At that speed, I have to be considering running the database locally.

Any ideas?

Thanks,
Liam

same here.
since a few days its very slow and nearly unusable.

is the database with wikiarticles also free for download ?
and what about the webservice scripts?.. i considered to mirror the whole webservice

Marc, could you please dump the actual wikipedia databases, like you did in this thread from 2006:

http://forum.geonames.org/gforum/posts/list/126.page#756

if possible in SQL, not COPY Format

thx

please? i need the webservice for my colloquium. But its still often not reachable.. so i have to set up a local db

I have transfer the postgresql wikipedia to mysql. If somebody are interested by this let me know where and how I can put the file on geonames server.

Also, they are recent version of wikipedia database ?

Pierre
http://www.map2explore.com

There are the steps to install Wikipedia database in mysql 5.1.

I make this migration from this file :
http://www.geonames.org/export/wikipedia/wikipedia.zip

There is the zip file wikipedia_mysql.zip.
Just read the readme.txt

Any comments and suggestions will be appreciate.

Pierre

cool, thx but why istnt there a column wikipediaUrl ?

I don't know. the column wikipediaUrl did not exist in version postgresql also.

Maybe Marc have a response...

I would like to know also.

Finally you don't need the field wikipediaUrl. Just put the language and the title in the url like this :

http://en.wikipedia.org/wiki/Zamora%2C_Spain

Originally the title was "Zamora, Spain " and I thing the browser convert it to this : Zamora%2C_Spain. I same for the french accents in the title