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
I am new to the group and to UniVerse. We are experiencing issues in
UniVerse 10.1.3 downloading data via the ODBC connection to SQL Server.
2.6 mil records can take 2 hours to complete. We are currently using
the default settings for the ODBC driver. I will soon make changes to
increase the
If it's speed you want, go with a text file dump of the data and then
an SQL bulk insert job. I did much the same thing (though with fewer
records) and improved performance dramatically. Sometimes the good
old tools really are better.
---
u2-users mailing list
u2-users@listserver.u2ug.org
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Brooks
Sent: Thursday, August 10, 2006 8:21 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe ODBC driver performance issues
I am new to the group and to UniVerse. We
performance issues
-Original Message-
From: [EMAIL PROTECTED] Behalf Of Chris Brooks
Sent: Thursday, August 10, 2006 8:21 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe ODBC driver performance issues
I am new to the group and to UniVerse. We are experiencing issues
-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
13 matches
Mail list logo