> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > HENDERSON MIKE, MR > Sent: Thursday, August 10, 2006 4:22 PM > To: u2-users@listserver.u2ug.org > 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/