John, It is abysmal because the NIC and the Ethernet are both gigabit. Thanks, Chris
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: Thursday, August 10, 2006 7:19 PM To: [email protected] Subject: RE: [U2] Universe ODBC driver performance issues {Unclassified} > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON > MIKE, MR > Sent: Thursday, August 10, 2006 4:22 PM > To: [email protected] > Subject: RE: [U2] Universe ODBC driver performance issues > {Unclassified} > > John, > > Chris is transferring on average about 360 (2.6M / 2 / 3600) records > per second. If the records are ~200 chars, then he's getting about > 700kb/sec (that's kb, not kB), or about 1.5% of the throughput you > might hope for on a 100Mbps Ethernet pipe! > So I'd say Chris does have an issue here. ODBC is known to be very chatty and inefficient, so you have to add quite a bit of overhead for the protocol itself (though I don't know how much). Even so, you're right, that's pretty poor performance over 100MB ethernet and it would be abysmal for a gigabit link. -John ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
