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