Re: large updates and deletes

2006-01-17 Thread Martin Hall
Robert Hicks wrote: I have been handed a couple of requests to change some data. One is an update on 3.6 million records and the other is two different deletions of over 16 million rows of data. I need to be able to do these in batches as I am told that Oracle will "blow up" if I do them in one

large updates and deletes

2006-01-17 Thread Robert Hicks
I have been handed a couple of requests to change some data. One is an update on 3.6 million records and the other is two different deletions of over 16 million rows of data. I need to be able to do these in batches as I am told that Oracle will "blow up" if I do them in one shot. I would like to

Re: Apache::DBI and DBD::Pg

2006-01-17 Thread Tim Bunce
On Mon, Jan 16, 2006 at 12:42:10PM -0800, Tyler MacDonald wrote: > Jeremy Nixon <[EMAIL PROTECTED]> wrote: > > It looks like it would work perfectly with connect_cached, which I hadn't > > known about, but now that I do, I'm all excited to change my code to use > > it instead of Apache::DBI. > >