Re: Inserts during a long select?

2002-01-22 Thread Egor Egorov
Tuesday, January 22, 2002, 8:43:55 AM, it is written: >> I have a large amount of date that I need to select from in order to >> generate reports (might take 20 minutes). I also have data >> continuously being inserted.. I don't mind if the select results >> doesn't contain the recently added r

Re: Inserts during a long select?

2002-01-21 Thread Jeremy Zawodny
On Mon, Jan 21, 2002 at 06:32:28PM -0800, Eric Mayers wrote: > I have a large amount of date that I need to select from in order to > generate reports (might take 20 minutes). I also have data > continuously being inserted.. I don't mind if the select results > doesn't contain the recently added

Inserts during a long select?

2002-01-21 Thread Eric Mayers
I have a large amount of date that I need to select from in order to generate reports (might take 20 minutes). I also have data continuously being inserted.. I don't mind if the select results doesn't contain the recently added rows (or it can -- I don't care). I've searched the archive and foun