[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