Thanks to my rather quick education in ASP yesterday, I was able to bypass my companies GUI in both queries and updates. I no longer have to worry about the Internet Explorer window crashing right in the middle of 10000 updates. The good news is I went from an average update time of 3-4 seconds to a consistent 70 milliseconds. A large improvement!
Sending the query to the server eats about 35 milliseconds. The server spits out a HTML page that is used for an IFRAME. I than have to turn this HTML junk into a usable XML string; this process eats up another 30 milliseconds. From here I make the update to the XML string, and then send it back to the server with an update tag attached; this only takes around 7 milliseconds!
My queries should go a lot quicker now, I don't have to make an update or convert the HTML into XML. I could feasibly run queries that respond in 35 milliseconds, and considering this is through the httprequest method, that's not too bad at all! I could run through 10000 customer entries in under an hour!
Monday, October 26, 2009
Subscribe to:
Posts (Atom)