the fastest, most efficient way to retrieve list of values from the db
hi! thanks for hitting this thread.
i was wondering what is the faster or fastest way to retrieve LOVs from the database. like for example, filling up a personal info form. then it has a html select object. that objects shows the list of countries (i guess that is more than two hundred). what i do is retrieve them values when the page loads and it does take a lot of time. AND THEN the user goes to another page that again contains a select that contains list of countries. then i would requery the same things just to populate the select object.
i was wondering what are other things or style or methods that i can try to use to get a LOVs from the database without or decreasing the amount of loading time for my page?
any suggestions would be appreciated