[thelist] Effcient ASP Script?

Adam Slesinger badlanners at hotmail.com
Mon Nov 25 14:45:00 CST 2002

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!


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


set conn = nothing

More information about the thelist mailing list