<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Geonames autocomplete - index "]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Geonames autocomplete - index "]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Geonames autocomplete - index </title>
				<description><![CDATA[ Hi,

I am facing an optimalization issue with Geonames. I have my own database (3M records, MySQL). I have a full text index on NAME and the second one on POPULATION. My query:

SELECT name FROM `geoname` WHERE MATCH(name) AGAINST ('Lo*' IN BOOLEAN MODE) ORDER BY population DESC LIMIT 10

Unfortunately, this query takes 31 seconds to get results. I wonder why. 

Thanks for any tips,
Xsnowy]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/3754.page#11208</guid>
				<link>http://forum.geonames.org/gforum/posts/list/3754.page#11208</link>
				<pubDate><![CDATA[Wed, 8 Feb 2012 06:09:37]]> GMT</pubDate>
				<author><![CDATA[ xsnowy]]></author>
			</item>
	</channel>
</rss>