title: How to present 200k selectable records on a website
body: <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>