Originally Posted by minder
One option is to get the <select> options only once from the db and store them in a session array. Getting data from the array each time it's needed will be quicker than getting it from the db.
Values saved in session for one user won't be available for another one - which means writing and reading a lot of data to/from the session may make more overheads.
Edit: I request a mod to move this to PHP section
I'm thinking about to make and synchronise an xml file from DB, with all option values. Can the system get any advantage when populating the <select> list from this xml file, when compared to the DB fetch operation?