How to present 200k selectable records on a website
<p>i have big problem on my site, i have this function to get all category from data base :-</p>

<pre><code>public function selectallcatdata()
{
    $query = mysql_query("select Category_name,Category_id from category where Category_delete='0'");
    return $query;
    mysql_free_result($query);
}
</code></pre>

<p>and i use this function on select type like this :-</p>

<pre><code>&lt;select name="txtCompanyCat" id="txtCompanyCat"&gt;
&lt;option selected value=""&gt;choose the Category ... &lt;/option&gt;
&lt;?php 
$CategoryNameData = $select -&gt; selectallcatdata();
while($CatNameRow = mysql_fetch_array($CategoryNameData)){
    $CatID = $CatNameRow['Category_id'];
    $CatName = $CatNameRow['Category_name'];
?&gt;
&lt;option value="&lt;?php echo $CatID; ?&gt;"&gt;&lt;?php echo $CatName; ?&gt;&lt;/option&gt;
&lt;?php } 
unset($CatID);
unset($CatName);
?&gt;
&lt;/select&gt;
</code></pre>

<p>So, the problem is i have 251932 rows on this table and we must show all this rows from my table, how can i solve this load.</p>
