Hi all,
-
I use PHP5/MYSQL5 ------------------ I need you to help, i have a serious problem when i look up records from database number of 18939 records in ComboBox ({value}). My webpages open so slow maybe 2 minutes or more, How can i make it faster than when there are many record like this. Please help me now. Thank you in advanced. Hy Chanhan
-
I use PHP5/MYSQL5 ------------------ I need you to help, i have a serious problem when i look up records from database number of 18939 records in ComboBox ({value}). My webpages open so slow maybe 2 minutes or more, How can i make it faster than when there are many record like this. Please help me now. Thank you in advanced. Hy Chanhan
You need to filter your recordset to include less results. Nobody, will look at a Combobox with 18000 items in it! Maybe you can use several comboboxes to categorize the results, so the last combobox will have just a few items. Example: combobox 1: States combobox 2: Counties combobox 3: Towns combobox 4: Cool Places Do you get my meaning?
- S 50 cups of coffee and you know it's on!
-
I use PHP5/MYSQL5 ------------------ I need you to help, i have a serious problem when i look up records from database number of 18939 records in ComboBox ({value}). My webpages open so slow maybe 2 minutes or more, How can i make it faster than when there are many record like this. Please help me now. Thank you in advanced. Hy Chanhan
In ASP you can use an application variable to cache the result of a database query. Then when a page loads you grab the variable instead of hitting the database, speeding things up and using less resources at the same time. PHP most likely has something similar. A search on google for "php application variable" resulted: http://www.leosingleton.com/projects/code/phpapp/[^]
"Half this game is ninety percent mental." - Yogi Berra If you can read thank a teacher, if you can read in English, thank a Marine. M y and h don't work so well due to m addiction to caffeine and m in abilit to to set a cup down uprigt.
