LOADING A COMBO:
In a sql query , I get a recordset of product codes, then I load a html combo box with it in a loop. I have about 1000 products and it takes about 12 seconds to do that, how come it's that long. Is there a better way to do this?

EXECUTING A QUERY:
I type some text in a textbox, on validation I have to check if this value is valid through a query. So basically, I am in a java script function and I have to do a query on the server. What I did is call a new window that executes the query and sends me back a value if it is valid, is there any way to do it better?