Re: Corrupt tables after long queries (fwd)

2001-04-19 Thread Sinisa Milivojevic
Peter Skipworth writes: > Hi all, > > Has anyone experienced anything like the following ? > > I have several queries which, admittedly, are quite complex and operate on > several million rows of indexed data. The tables are naturally locked > while the query occurs, which is fine, but what is *

Corrupt tables after long queries (fwd)

2001-04-18 Thread Peter Skipworth
Hi all, Has anyone experienced anything like the following ? I have several queries which, admittedly, are quite complex and operate on several million rows of indexed data. The tables are naturally locked while the query occurs, which is fine, but what is *not* fine is that occasionally, comple

Corrupt tables after long queries

2001-04-18 Thread Peter Skipworth
Hi all, Has anyone experienced anything like the following ? I have several queries which, admittedly, are quite complex and operate on several million rows of indexed data. The tables are naturally locked while the query occurs, which is fine, but what is *not* fine is that occasionally, comple