to provide you
with professional help.
Good luck!
Mike
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Brooks
Sent: Saturday, 12 August 2006 02:02
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues
Make sure the two machines can swap data at network speed with
something as simple as a file copy. If that goes fast(er) then you
know it's something within the database systems, if it's the same then
you have a network issue that needs to be figured out. I've found in
the past that making sure
Chris are you pulling data into SQL Server from UniVerse through an ODBC
connection or are you pushing the data to the SQL Server through BCI.
Regards
David Jordan
Managing Consultant
[EMAIL PROTECTED]
Chris is transferring on average about 360 (2.6M / 2 / 3600)
records per
second. If the
Of HENDERSON MIKE,
MR
Sent: Thursday, August 10, 2006 6: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
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: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues
] Universe ODBC driver performance issues {Unclassified}
Chris are you pulling data into SQL Server from UniVerse through an ODBC
connection or are you pushing the data to the SQL Server through BCI.
Regards
David Jordan
Managing Consultant
[EMAIL PROTECTED]
Chris is transferring on average about 360
@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues {Unclassified}
Chris are you pulling data into SQL Server from UniVerse through an ODBC
connection or are you pushing the data to the SQL Server through BCI.
Regards
David Jordan
Managing Consultant
[EMAIL PROTECTED]
Chris
Hi Chris
Why don't you try pushing the data to SQL server using UvBasis and BCI, this
may overcome some of the inefficiencies of ODBC
Regards
David Jordan
Managing Consultant
David
We are pulling data into SQL Server from UniVerse through an ODBC
connection.
Thanks
Chris
---
u2-users
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.
I
-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
10 matches
Mail list logo