<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Data results so slow in autocomplete"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Data results so slow in autocomplete"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Data results so slow in autocomplete</title>
				<description><![CDATA[ Hello,
I tried to use jQuery autocomplete with 'geonames' and 'admin1_codes' tables imported in my mysql DB.
I simply made a mysql query in this way:
<span class="genmed"><b>Code:</b></span><br>
		<div style="overflow: auto; width: 100%;">
		<pre>
            public function printResult&#40;&#41;
            {
                $sql = "SELECT  geoname_id,name,admin1_code,country_code FROM geonames WHERE name LIKE '$this-&gt;term%' ORDER BY name ASC LIMIT 20 ";
                $res = mysql_query&#40;$sql, $this-&gt;conn&#41; or die&#40;mysql_error&#40;&#41;&#41;;
     
                $return = array&#40;&#41;;
                $arr = array&#40;&#41;;
     
                while&#40;$row = mysql_fetch_array&#40;$res&#41;&#41;
                {
                    $arr&#91;'id'&#93; = $row&#91;'geoname_id'&#93;;
		    $arr&#91;'value'&#93; =  $row&#91;'name'&#93;. 
                    array_push&#40;$return, $arr&#41;;
                }
     
                echo json_encode&#40;$return&#41;;
            }</pre>
		</div>

but it appears very very slow to show results.
Have you a better solution?
Thanks.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/3764.page#11239</guid>
				<link>http://forum.geonames.org/gforum/posts/list/3764.page#11239</link>
				<pubDate><![CDATA[Thu, 16 Feb 2012 06:07:39]]> GMT</pubDate>
				<author><![CDATA[ Tab]]></author>
			</item>
	</channel>
</rss>