[thelist] Effcient ASP Script?

[Chris Blessing]

Adam-

What is the DBMS behind this? SQL Server?

If so, you can use the TOP clause to get just the first 2000 records,
significantly reducing your recordset overhead.

Example:

SELECT TOP 10 field1, field2 FROM myTable

Also, define the fields you want to select in your query, rather than
selecting *.

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> 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