Re: [ADMIN] [GENERAL] performance issue using DBI

2002-06-07 Thread Joshua b. Jore
How much data is 20,000 lines? 20KB? 100MB? You might do well to just process this in memory and then just COPY the right data to the table. This gets away from doing the SELECT/INSERT/SELECT/INSERT thing which is going to be painful for batch jobs. See, the thing is that on every insert the inde

Re: [ADMIN] [GENERAL] performance issue using DBI

2002-06-07 Thread Joshua b. Jore
Oh ok. So I was thinking of the way that sequences cut across transactions and I misinterpreted it. Thanks for the clarification. Joshua b. Jore ; http://www.greentechnologist.org ; 1121 1233 1311 200 1201 1302 1211 200 1201 1303 200 1300 1233 1313 1211 1302 1212 1311 1230 200 1201 1303 200 1321