BenAtODE
08-28-2002, 06:42 PM
Hello,
I am using the javascriptkit.com triple combo script on my page, but instead of hard coding the options, I populating the combo boxes with database calls and looping (it is very important that a change in the database also results in a change in the options in the combo box).
Each combo box selects out of a specific table. When an option is selected from the first combo (from Table A), the second combo lists all of the elements in Table B that have the selected option from Table A as a parent. When one of these options in the second combo is selected, the third combo lists all of the options in Table C with the selected option in Table B as a parent.
It works fabulously, except for one problem. There are about 8 possible options for the first combo, about 550 for the second, and about 8500 for the third one. The code generated by my asp page is about 28000 lines long, and takes about five minutes to load every time the page is accessed. Any ideas on how to lower the load time? I am using three ODBC connections...would just one improve things at all?
I am using the javascriptkit.com triple combo script on my page, but instead of hard coding the options, I populating the combo boxes with database calls and looping (it is very important that a change in the database also results in a change in the options in the combo box).
Each combo box selects out of a specific table. When an option is selected from the first combo (from Table A), the second combo lists all of the elements in Table B that have the selected option from Table A as a parent. When one of these options in the second combo is selected, the third combo lists all of the options in Table C with the selected option in Table B as a parent.
It works fabulously, except for one problem. There are about 8 possible options for the first combo, about 550 for the second, and about 8500 for the third one. The code generated by my asp page is about 28000 lines long, and takes about five minutes to load every time the page is accessed. Any ideas on how to lower the load time? I am using three ODBC connections...would just one improve things at all?