We are using UVODBC to connect our web site to our production UV database and we also experience a FIRST CONNECT lag time. Subsequent queries are processed almost immediately. We have considered creating a routine on the server to periodically query UV so that any user would hopefully be the SECOND CONNECT.
Garry Smith Dir. Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 CONFIDENCE NOTICE: This is an e-mail message, theretofore may have many accompanying documents, and is truly for the intended recipient(s) and heretofore may contain data and information. Surely any unauthorized review, use, disclosure, distribution or copying could become arum nauseous. If you are not the intended recipient, please look deep within yourself by any means and immediately forgo digesting the original message. > -----Original Message----- > From: Andy Moore [SMTP:[EMAIL PROTECTED] > Sent: Thursday, September 09, 2004 3:42 AM > To: [EMAIL PROTECTED] > Subject: [U2] UVODBC first query > > We are using a report writer called Bi/Query with Universe via the > UVODBC and have noticed that once connected to the database, the first > query has a delay of about 20 seconds before it returns any results. > > Further queries after this time run immediately without the delay, but > leaving the session without activity for about 5-10 minutes means that > the next query again has a 20 second delay before returning any results. > > We have noticed this on many of our customer sites, has anyone else > experienced this delay with the UVODBC or aware of what may cause this > or how to fix it? > > Thanks > > > Andy Moore > Selima Software Ltd > Tel: 0114 2815000 > Fax: 0114 2817777 > email: [EMAIL PROTECTED] > ------- > 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/
