vb.net web form performance issue
I have a web form that interacts with a database. when you select an item from one of two corresponding combo boxes, it sets the other combobox to the an equivalent value by reloading the page.
Dropdown boxes:
box 1 box2
1 red
2 blue
3 green
if you select box 1 to "1" box two will be set to red when the page reloads. if you select "green" for box 2, box 1 will be set to "3" when the page reloads.
sometimes this works but is slow.... It takes a good 6 or 7 seconds to rerun the page. Worse, if i change the box a few times, it eventually just reloads a blank web page, with no form on it at all. Am I doing something wrong? Can I expect better performance when I move this from my laptop to a real server (accessing a separate SQL server)?
IT was the database connection...
You answered my other post too... The problem was that I was populating the table from a sql server db and every postback was making a new connection. I found a way to read the info i needed into hashtables and save that in the viewstate so that on a postback I did not need to connect again. Thank you.