[thelist] Re: Effcient ASP Script?
Adam Slesinger
badlanners at hotmail.com
Mon Nov 25 15:48:00 CST 2002
Thanks everyone, for all of those great tips. Many of you have shown me
that I still have a lot to learn about coding ASP and ADO efficiently. I
will play with all of your suggestions. Much appreciated!
adam
----- Original Message -----
From: "Adam Slesinger" <badlanners at hotmail.com>
To: <thelist at lists.evolt.org>
Sent: Monday, November 25, 2002 3:45 PM
Subject: Effcient ASP Script?
> Hi folks!
>
> I am writing a page that selects all records with company names and then
> updates the type of those records if they are the first 2000 records. The
> database has a total of 13,000 records. When I run this on my server, it
> takes a long time, and then times out.
>
> My 1st questions is, how can I keep any script in general from timing out?
>
> My 2nd question is - is my code efficient? I wouldn't think that it would
> take so long for this process to run, but it only gets through about 1400
> records before the timeout happens.
>
> Any help is appreciated!
>
> Thanks,
> adam
>
> set conn = server.createObject("ADODB.Connection")
> conn.open Session("connection")
> set rstemp = server.createobject("ADODB.Recordset")
>
> SQL = "SELECT * FROM registrants WHERE company <> ''"
> rstemp.open SQL, conn
>
> do while not rstemp.eof
> strCount= strCount+ 1
>
> if strCount <= 2000 and strCount > 0 then
> 'Update Type
> set typeUpdate= conn.execute("UPDATE registrants SET type= 1 WHERE
> company = '" & rstemp("company") & "'")
> end if
>
> rstemp.moveNext
> loop
>
> conn.close
> set conn = nothing
>
More information about the thelist
mailing list