RE: [U2] Universe ODBC driver performance issues {Unclassified}

2006-08-11 Thread Chris Brooks
- From: [EMAIL PROTECTED] On Behalf Of John Hester Sent: Friday, 11 August 2006 08:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe ODBC driver performance issues -Original Message- From: [EMAIL PROTECTED] Behalf Of Chris Brooks Sent: Thursday, August 10, 2006 8:21 AM

RE: [U2] Universe ODBC driver performance issues {Unclassified}

2006-08-11 Thread Chris Brooks
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: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe ODBC

RE: [U2] Universe ODBC driver performance issues {Unclassified}

2006-08-11 Thread Chris Brooks
David We are pulling data into SQL Server from UniVerse through an ODBC connection. Thanks Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Friday, August 11, 2006 4:44 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]

RE: [U2] Universe ODBC driver performance issues {Unclassified}

2006-08-11 Thread Chris Brooks
Does anyone have experience changing the MAXFETCHCOLS and MAXFETCHBUFF. Are they change on both the client and the server? Thanks Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Friday, August 11, 2006 4:44 AM To:

[U2] Universe ODBC driver performance issues

2006-08-10 Thread Chris Brooks
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