Re: anyone use Ora2Pg?
От | Ron Johnson |
---|---|
Тема | Re: anyone use Ora2Pg? |
Дата | |
Msg-id | 1064011782.3391.26.camel@haggis обсуждение исходный текст |
Ответ на | Re: anyone use Ora2Pg? ("Johnson, Shaunn" <SJohnson6@bcbsm.com>) |
Список | pgsql-general |
On Fri, 2003-09-19 at 15:32, Johnson, Shaunn wrote: [snip] > * Johnson, Shaunn (SJohnson6@bcbsm.com) wrote: > > --i had tried to use 'copy', but it was taking > > --so long ... it took over a weekend to load > > --about the same amount of records as using 'insert' (i have > > --been running this program for over 2 days and only > > --have 2800 records to show out of 1/2 a million records). > > > > --i was looking for something faster. could be my server ... > > --looking at the system usage, it doesn't seem very high. > > Something sounds pretty off. It didn't take nearly that long for me > to > load up a fair bit of data. Could the table be chock full of indexes? Still, 2 days to insert 2800 records is less than 1 record per *minute*. That's not "pretty off", that's mondo off. -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA "Fair is where you take your cows to be judged." Unknown
В списке pgsql-general по дате отправления: