Very Computer

by **Serge Tkacho** » Thu, 01 Apr 1999 04:00:00

I wrote an ASP script to add records to a table in SQL Server 7 from a
similar table in Access - Added 35000 records in a few minutes. Now I am
trying to delete most of those records (about 34000) and it is going VERY
SLOW, so far the script has been running for about 2 hours. Any hints as to
how to speed it up?

I use the following code:

rs.Open "SELECT * FROM ShortStories WHERE DateTime < '"&date&"'", strDSN,
1, 3, &H0001

Do While NOT rs.eof
rs.Delete
rs.MoveNext
Loop

TIA,
-serge

by **Patrice Scrib** » Thu, 01 Apr 1999 04:00:00

You may want to try a DELETE query instead...

Patrice Scribe

Serge Tkachov a crit dans le message

Quote:>I wrote an ASP script to add records to a table in SQL Server 7 from a
>similar table in Access - Added 35000 records in a few minutes. Now I am
>trying to delete most of those records (about 34000) and it is going VERY
>SLOW, so far the script has been running for about 2 hours. Any hints as to
>how to speed it up?

>I use the following code:

> rs.Open "SELECT * FROM ShortStories WHERE DateTime < '"&date&"'", strDSN,
>1, 3, &H0001

> Do While NOT rs.eof
> rs.Delete
> rs.MoveNext
> Loop

>TIA,
>-serge

by **Mike** » Sat, 03 Apr 1999 04:00:00

DELETE FROM ShortStories WHERE mycondition is true
should work as fast as the insert/update

>I wrote an ASP script to add records to a table in SQL Server 7 from a
>similar table in Access - Added 35000 records in a few minutes. Now I am
>trying to delete most of those records (about 34000) and it is going VERY
>SLOW, so far the script has been running for about 2 hours. Any hints as to
>how to speed it up?

>I use the following code:

> rs.Open "SELECT * FROM ShortStories WHERE DateTime < '"&date&"'", strDSN,
>1, 3, &H0001

> Do While NOT rs.eof
> rs.Delete
> rs.MoveNext
> Loop

>TIA,
>-serge

by **JRSte** » Sun, 04 Apr 1999 04:00:00

On Fri, 2 Apr 1999 09:36:24 -0600, "MikeC"

>DELETE FROM ShortStories WHERE mycondition is true
>should work as fast as the insert/update

I have found delete in SQL7 to run very slowly, maybe as fast as
individual inserts but far slower than global updates.

Joshua Stern

Very Computer

Adding records vs. Deleting records

Adding records vs. Deleting records

Adding records vs. Deleting records

Adding records vs. Deleting records

Adding records vs. Deleting records