How to optimize jquery choosen plugin for loading more than 50k results
I am using class 'chosen-select' for loading all product names.When the
user clicks on product_select , it takes lot of time to load.What can be
done to improve performance.
<select class='chosen-select' data-placeholder="Choose a product..."
id="product_select">
<option></option>
<?php
include 'connection.php';
$query = "SELECT * FROM " . $table_name;
$result = mysqli_query($con, $query);
$results = array();
while ($line = mysqli_fetch_assoc($result))
{
$results[] = $line;
}
$i = 0;
foreach ($results as $r)
{
$i++;
echo "<option value=" . $r['id'] . ">" . $r['Product_name']
. "</option>";
}
?>
</select>
<script>
$('#product_select').chosen({max_selected_options: 1});
</script>
No comments:
Post a Comment