Hello. I have a simple question regarding a web page i made that involves a form containing three drop down menus. These three fields contain numerous values, one with around around 600 account numbers and the others with around 200 teritories. When i click the submit button on the form, it takes quite a long time (close to 30 seconds) for it to actually insert the record into the database. Does anyone have any suggestions why this is happening? Any help would be greatly appreciated.
You really don't give enough information for anyone to give any kind of good answer. Why do YOU think it is taking so long? What database are you using? Is this a single INSERT or UPDATE into the database? Are you using automated tools to accomplish this, or did you hand code the procedure?