Databases
StackOverflow2013
Postsdbo
POlarge select slowing down page load - caching php
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POlarge select slowing down page load - caching php
    primarykey
    data
    text
    <p>I'm building a web app, the way I started off the app for testing purposes is to load lots of data in to session arrays from my database so I can use the values easily throughout the pages. I have one page the has numerous selects on it, and each time the php page loops through all the variables, chooses the selected one, and outputs the dropdown. One of my arrays though has just under 3000 values and loading this dropdown slows the page down from about 300ms to 1-1.2s. Not terrible but easy to tell that it is less responsive. So I'd like to know if there is anyway for me to improve the load speed, or any thoughts on a substitute for the dropdown.</p> <p>What I have tried so far:</p> <ol> <li><p>Session arrays hold all the values, when the page is loaded through jquery ajax method the php page loops through these values and echos the dropdowns.</p></li> <li><p>Php include - create php or html pages of all the values pre written as selects, this creates a ~100kb page for the problem dropdown and this is then included with <code>include</code>. Takes roughly the same amount plus I'd have to then use javascript to set the value, but I'd do this if it could be improved. I thought perhaps some caching could provide improvements here. There seemed to be no significant difference between html and php pages for include but I'd assume html would be better. I'm also assuming that I cannot use regular caching because I am using a php function to include these pages.</p></li> <li><p>I have tried just loading in the html page and it takes about 1 sec on first load, after browser caching it is back down to 100-350ms so I imagine caching could provide a huge boost in performance.</p></li> </ol> <p>I have considered:</p> <ol> <li><p>Creating a cached version of the whole page but this will be quite the pain to implement so I'd only do it if people thought it is the right way to go with this. I would have to use ajax to retrieve some data for the inputs which I was originally doing with php echos. </p></li> <li><p>Just removing the problem dropdown.</p></li> </ol> <p>Just to clarify something I've never had clarified, am I correct in thinking php pages can never be cached by the browser, and so by extension any php included files can't be either. But then how come a javascript file linked to in a php file can be cached, because it is using an html method?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmrmryb
    1. USmrmryb
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThe PHP code cannot be cached, but the resulting HTML can. That is why the javascript you mention is being cached.
      singulars
      1. POlarge select slowing down page load - caching php
      1. USAdam Culp
    2. CO@AdamCulp But would the resulting HTML from a php include be cache-able then?
      singulars
      1. POlarge select slowing down page load - caching php
      1. USmrmryb
    3. CONot really, because the PHP re-renders it each time, unless you have an optcode cache as I stated in my answer below. That may help.
      singulars
      1. POlarge select slowing down page load - caching php
      1. USAdam Culp
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload