Posted by Wolfing on 06/15/07 16:51

On Jun 15, 12:17 pm, Seribus Dragon <Seribus.n...@seribus.com> wrote:
> Are those section that are getting the dead lock just doing read only or
> do the need to right?
>
> Wolfing wrote:
> > I have a table that every 30 minutes needs to be repopulated from
> > another table that is recreated from scratch just before.
> > What I did was this:
> > CREATE PROCEDURE BatchUpdProducts AS
> > begin transaction
> > delete products
> > insert into products
> > select * from productsTemp
> > commit transaction
> > GO
>
> > This takes about 30 seconds to run. I tried it doing it with a cursor,
> > row by row, but it took like 30 minutes to run instead. The problem
> > is with the fast approach is, once in a while I get a deadlock error
> > in different areas trying to access the products table. Using SQL
> > Server 2000 by the way.
> > Any ideas?

Only read, the only process that writes is the one I showed above that
runs every 30 minutes

[Back to original message]