[thelist] Effcient ASP Script?
Chris Blessing
webguy at mail.rit.edu
Mon Nov 25 14:51:01 CST 2002
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
More information about the thelist
mailing list