php - How to optimize jquery chosen plugin for loading more than 50k results -

-

i using class 'chosen-select' loading product names.when user clicks on product_select , takes lot of time load.what can done improve performance.

<select class='chosen-select' data-placeholder="choose product..." id="product_select">   <option></option>          <?php           include 'connection.php';             $query = "select * " . $table_name;             $result = mysqli_query($con, $query);             $results = array();            while ($line = mysqli_fetch_assoc($result))            {                    $results[] = $line;            }            $i = 0;            foreach ($results $r)            {                $i++;                echo "<option value=" . $r['id'] . ">" . $r['product_name'] . "</option>";            }           ?> </select>  <script>      $('#product_select').chosen({max_selected_options: 1});  </script>

what should do

it's not idea serving many options in 1 go, sanity of users. if me i'd switch auto-complete model or way user narrow option request down subset before requesting, however, here tips on can use optimise.

what can do

the real point can optimise — without rewriting jquery plugin — improve things @ server-side. include (as stated samuel liew) caching servers response, improving connection database i.e. make sure dealing local database rather remote. simple steps can towards faster queries:

by specifying target fields rather using * may large number of rows.

15 tips on optimising mysql queries

even changing type of database/table can — example, if hardware has low disk write speed/efficiency try running table memory. these kinds of options require must have lot of control on database server , database config, if using shared host unlikely can of anything... may have choice between using mysql or sqlite though, enough switch between disk-based database more memory-based one. if running dedicated server there whole host of things can optimise mysql, takes lot of reading (it's complicated subject), thread hints @ of things can mysql:

optimal mysql-configuration (my.cnf)

one thing may help, depend on how memory database instance has, build html in query. wouldn't advise complicated queries, generating quite simple. following assumes mysql usage:

select    group_concat(     '<option value="',id,'">', name, '</option>' separator ''   ) html   $table_name    group null

once you've got database bringing html want php, either cache result in db table, or file in local filesystem; on next request option list should serve cached location instead — , continue until prefixed expiry time (or cache deleted).

the following link explains rough process, needs write result brought database; rather ob_get_contents() in example — 1 way server-side cache however.

easy server-side caching in php

client-side caching

depending on how displaying input or how users might encounter it, optimise on client-side (for browsers support it) using window.localstorage object. allow put check of localstorage before making ajax select request, if have options html stored there can use instead , cut out request entirely. there seems unofficial storage limit of 5m localstorage should cover 50000 items. wouldn't speed things user's first visit, subsequent visits should improved quite bit. should bear in mind way cache cleared if database table updated.


Comments

Post a Comment

Popular posts from this blog

java - activate/deactivate sonar maven plugin by profile? -

-
i use sonar plugin executes if activated in maven profile. sonar runs on every compile. the problem build fail other team members not have sonar application installed locally. pom.xml checked in team members same copy including sonar configuration, don't want them modify purpose of disabling sonar (they might inadvertently check modified copy in). please advise how configure maven (.m2/settings.xml) and/or pom.xml sonar feature can enabled/disabled local profile. here sonar configuration in each project's pom.xml: <plugin> <groupid>org.codehaus.mojo</groupid> <artifactid>sonar-maven-plugin</artifactid> <version>1.0</version> <executions> <execution> <id>make-sonar</id> <phase>compile</phase> <goals> <goal>sonar</goal> </goals> </execution> </executions> ...
Read more

python - TypeError: can only concatenate tuple (not "float") to tuple -

-
i'm new python, question might easy, anyway, patience: as trying call newton-raphson method calculate implied volatility in black-scholes formula call/put option pricing, first thing is, newton method in scipy.optimize seems calculate function's zeros, in black-scholes formula, want function's value option price, not zero. (i'm new here programming, i'm not sure techniques.) should write function things like: def f(sigma, price): return bsformula(s0,k,r,t,q,sigma) - price then, while calling newton method, takes args=() 1 parameter in function, write this: value = newton(bsprice2, 0.5, args=price) but error message: file "bs.py", line 36, in bsimpvol value = newton(bsprice2, 0.5, args=float(price)) file "/usr/lib/python2.7/dist-packages/scipy/optimize/zeros.py", line 143, in newton q0 = func(*((p0,) + args)) typeerror: can concatenate tuple (not "float") tuple could tell me why that? how fix it? apprecia...
Read more

java - What is the difference between String. and String.this. ? -

-
this question has answer here: meaning of .this , .class in java 2 answers i'll straight point. im still learning bit of syntax , want know difference between code is code a: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.valueof(i))); } } please ignore fact i undeclared, not lost. code b: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.this.charat(i))); } } what don't yet understand difference in typing string.this , string. i under assumption when use dot operator on class accessing it's static methods(and/or variables if they're not hidden). i have studied little bit , have concluded when using string. accessing string static methods.. when using string.this. i'm accessing methods class buttonz extendi...
Read more