We have noticed that the first connection of the day takes longer then subsequent reads. We use ODBC for reads only. We created a separate UV account with scaled down dictionaries that have I-descriptors with UV basic code to extract the Multi-value fields and format as need for our application.
The primary application for ODBC is our UPS shipping system to read SHIP-TO and Package data. If you have Multi-value fields the SQL INSERT and UPDATE probably will not work. For our web site we use RedBack since the ODBC could not provide the speed required. (IBM(r) U2 Web Development Environment for UniData and UniVerse (U2 Web DE) is the new name for RedBack) Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Martel, Henry Sent: Thursday, March 05, 2009 5:29 AM To: [email protected] Subject: [U2] ODBC Connection to Universe on HP-UX We are thinking of changing our application connect to Universe through ODBC connections. Has anyone had experience doing this? Are there any performance issues or considerations that we need to be aware of? Thanks, Henry. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
