> -----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 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 prefetch and threshold values. Any experience with the > ideal settings? From my testing the best performance seems to be at > prefetch = 16383 and threshold = 4096 on the ODBC driver. At this > settings seem to get a 30% performance increase. I would > like to see it > improve even more. > > > > To complicate things the UniVerse is using a SAN for storage. > Multiple > processors on the box and they are set to multi-threaded operations. > During the download the CPU is utilized less than 10%.
Sounds like you're I/O bound, although 2.6 million records in 2 hours isn't all that bad in my experience. Is it possible you're hitting the threshold of your NICs, or competing with a lot of other network traffic? If both machines have multiple NICs, you could reserve one on each machine for only talking to the other. You could add an entry to the hosts file on each so it would only know the other machine by the reserved NIC's IP, then just make sure the reserved IP addresses don't exist in DNS so no other machines will use them. If the machines are physically close, a crossover cable from NIC to NIC would eliminate any switch performance issues. At that point a rough calculation of your throughput based on the average size of each record would tell you if you're utilizing the available bandwith, or if there's some other bottleneck. -John ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
