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 rows (or

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

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