[thelist] Effcient ASP Script?

[Paul Roub]

I would also update all-at-once, or at least many-at-once.

So build a comma-separated list of matching companies as you go:

	if (strCompanies <> "") then
		strCompanies = strCompanies & ","
	end if

	strCompanies = strCompanies & "'" & rstemp("company") & "'"

then, when all is said and done,

	conn.execute("update registrants set type=1 where company in (" &
strCompanies & ")"

Yes, this will be an enormous statement (you may want to break it up into
smaller chunks to avoid SQL Server limitations -- I don't have docs handy to
say whether there *are* any here), but many round-trips go away.

Of course, my *real* first question would be -- why are you doing this?  Is
there a better approach to whatever your'e trying to accomplish?

-paul


-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Chris Blessing
Sent: Monday, November 25, 2002 3:55 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Effcient ASP Script?


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

--
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !