有没有办法缓存从数据库中填充的多个选择菜单

Question

I have a big form with 132 (12x11) select menus which are populated from the db (MySQL). The problem is obvious: page takes a long time to load because of all those db calls.

The structure of the form: there is a 12 separate sections each for 1 room with 11 dropdowns each (here is the link http://tinypic.com/view.php?pic=6tfjpk&s=7).

From 11 of those dropdowns 8 are the same "Room Description". Is there a way....I could somehow cache those dropdowns especially those 8 from the section 1 (room 1) and then just reload the cache for all other sections (other 11)? I tried to make the array in the function (which creates the dropdown from the database) with dynamic variables assigned to be static static ${$var_name};

but php parser itself doesn't allow dynamic variables to be static.

Answer 1

Problem solved!

@AJ

1. 1st part of the solution was to save the arrays from query into the session (AJ's recommendations). It helped, but not a lot (not as much as I expected saved me only 0.5 sec of page load. Page was loading before in 4,79 seconds afters this implementation... in 4,47sec's.

2. This part is an actual solution.

at the beginning of my code in dorpdown function I had this code:
$dbh = new PDO(CONFIG_MYSQL_DSN, CONFIG_MYSQL_USERNAME, CONFIG_MYSQL_PASSWORD, array(PDO::ATTR_PERSISTENT => false));

$dbh -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

which means that I was creating a new db connection every time the function has been called. I made when I created the function some time ago and it was supposed to be used only for testing purposes because I actually have include file on every page which is making sure I'm connected to the database. It has an option array(PDO::ATTR_PERSISTENT => true.

So, in order to avoid making db connection every time the dropdown function has been called I've set the $dbh to globalglobal $dbh; in that include file. I've also set global $dbh; in the function itself. Now page is loading in ONLY 0.6 seconds instead of 4.76 what is a GREAT IMPROVEMENT!