GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
MySQL InnoDB vs MyISAM, which one is faster for GeoNames data?  XML
Forum Index -> General
Author Message
[Post New]22/12/2008 15:35:01
    Subject: MySQL InnoDB vs MyISAM, which one is faster for GeoNames data?
[Up]
SEO



Joined: 14/10/2008 18:58:20
Messages: 18
Offline
As it seems in the following post InnoDB has become a lot faster then MyISAM in the recent years (it used to be slower as it seems).

http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/

Does anyone have any experience with this? What database storage engine is the best choice for GeoNames data?
[Post New]23/12/2008 21:51:05
    Subject: Re:MySQL InnoDB vs MyISAM, which one is faster for GeoNames data?
[Up]
SEO



Joined: 14/10/2008 18:58:20
Messages: 18
Offline
Also, it seems the GeoNames.org webservice uses PostgreSQL. However, isn't this much slower then MySQL?

[Post New]23/12/2008 21:52:23
    Subject: Re:MySQL InnoDB vs MyISAM, which one is faster for GeoNames data?
[Up]
SEO



Joined: 14/10/2008 18:58:20
Messages: 18
Offline
Ofcourse FULLTEXT search is missing in InnoDB, however, SphinxSearch may offer an alternative FULLTEXT search for InnoDB and FULLTEXT search may also be added by default in future MySQL versions.

http://www.sphinxsearch.com/
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team