On Fri, 2003-09-19 at 15:32, Johnson, Shaunn wrote: [snip] > * Johnson, Shaunn ([EMAIL PROTECTED]) 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. [EMAIL PROTECTED] Jefferson, LA USA "Fair is where you take your cows to be judged." Unknown ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
