RE: [U2] UVODBC first query
I tried the nslookup command on the server and got the following reply *** 192.168.25.143 can't find nslookup:No response from server Any other advice before I start playing with it? Set it up on the Unix box, if it is a static IP. Crudest (and easiest) way is to put it into the hosts file (/etc/hosts) Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC first query
We found the problem on our systems by doing "ping -a ip". For some servers this returned the name, others it returned the name after a long pause and others still it never returned the name just the ip. This was on Windows servers. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore Sent: 13 September 2004 10:08 To: [EMAIL PROTECTED] Subject: RE: [U2] UVODBC first query DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. I tried the nslookup command on the server and got the following reply > nslookup 192.168.25.143 Server: [192.168.25.143] Address: 192.168.25.143 *** 192.168.25.143 can't find nslookup:No response from server So I presume that this suggests that you could be right about the reverse lookup problem. It's a Unix server, which I don't have too much experience with, unlike Windows, but I should be able to work it out. Any other advice before I start playing with it? Thanks Andy Moore Selima Software Ltd. -Original Message- From: Ian McGowan [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 21:50 To: '[EMAIL PROTECTED]' Subject: RE: [U2] UVODBC first query A common cause of long delays when first connecting is reverse dns lookups. Your PC is 192.168.1.100 and you're telneting to a server. It does a lookup of 192.168.1.100 to record the host name and it can take a while for dns to come back that it doesn't exist. The dns query is cached, so connecting a few minutes later is fast. The best solution is to setup a reverse lookup domain, but adding dummy records to /etc/hosts (or %systemroot%\system32\drivers\etc\hosts) like: pc100 192.168.1.100 pc101 192.168.1.101 Works too. If "nslookup 192.168.1.100" doesn't return your pc host name, then this might be worth checking... > -Original Message- > From: Adrian Matthews [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 09, 2004 12:21 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] UVODBC first query > > > Are you sure? Certainly doesn't happen on any of our servers, > connection is near enough instant whether via telnet, uniobjects or > JDBC. > > > > From: [EMAIL PROTECTED] on behalf of Don Verhagen > Sent: Thu 09/09/2004 17:52 > To: [EMAIL PROTECTED] > Subject: RE: [U2] UVODBC first query > > > > I know this happens even with TELNET on Window Servers. It has > something do with the first time it looks up a username in the doman > and then it caches the the user tree (probably wrong term) of all the > users. So each login after than does NOT have to retrieve a list of > users. Does that make sense? > > Thanks, > > > -- > Donald Verhagen > Application Development Manager > [EMAIL PROTECTED] > Tandem Staffing Solutions, Inc. > 1690 S Congress Avenue, Suite 210 > Delray Beach, FL 33445 USA > Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 > > >>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>> > 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, >
RE: [U2] UVODBC first query
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. I tried the nslookup command on the server and got the following reply > nslookup 192.168.25.143 Server: [192.168.25.143] Address: 192.168.25.143 *** 192.168.25.143 can't find nslookup:No response from server So I presume that this suggests that you could be right about the reverse lookup problem. It's a Unix server, which I don't have too much experience with, unlike Windows, but I should be able to work it out. Any other advice before I start playing with it? Thanks Andy Moore Selima Software Ltd. -Original Message- From: Ian McGowan [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 21:50 To: '[EMAIL PROTECTED]' Subject: RE: [U2] UVODBC first query A common cause of long delays when first connecting is reverse dns lookups. Your PC is 192.168.1.100 and you're telneting to a server. It does a lookup of 192.168.1.100 to record the host name and it can take a while for dns to come back that it doesn't exist. The dns query is cached, so connecting a few minutes later is fast. The best solution is to setup a reverse lookup domain, but adding dummy records to /etc/hosts (or %systemroot%\system32\drivers\etc\hosts) like: pc100 192.168.1.100 pc101 192.168.1.101 Works too. If "nslookup 192.168.1.100" doesn't return your pc host name, then this might be worth checking... > -Original Message- > From: Adrian Matthews [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 09, 2004 12:21 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] UVODBC first query > > > Are you sure? Certainly doesn't happen on any of our servers, > connection is near enough instant whether via telnet, uniobjects or > JDBC. > > > > From: [EMAIL PROTECTED] on behalf of Don Verhagen > Sent: Thu 09/09/2004 17:52 > To: [EMAIL PROTECTED] > Subject: RE: [U2] UVODBC first query > > > > I know this happens even with TELNET on Window Servers. It has > something do with the first time it looks up a username in the doman > and then it caches the the user tree (probably wrong term) of all the > users. So each login after than does NOT have to retrieve a list of > users. Does that make sense? > > Thanks, > > > -- > Donald Verhagen > Application Development Manager > [EMAIL PROTECTED] > Tandem Staffing Solutions, Inc. > 1690 S Congress Avenue, Suite 210 > Delray Beach, FL 33445 USA > Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 > > >>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>> > 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
RE: [U2] UVODBC first query
I am ammending my answer [grin]. I was thinking of the reverse dns lookup too (See Adrian.Matthews post), not the user tree being cache. Hey I remember it caching *something*. So sue me, or better yet hit me with 3 hurricanes in 1 month (This wasn't was in the disaster recovery plan!) Thanks, Don (If it's not raining, it's not summer in Florida) >>> [EMAIL PROTECTED] 4:46:42 AM 09/10/2004 >>> DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. The telnet connections aren't affected by the same delay that the UVODBC is. And as far as I know we are using the server's IP in the UVODBC configuration. We also found on Windows servers that including the full path to the account you are connecting to instead of just the account name also improves performance, but it still doesn't remove the first query pause. Thanks for the suggestions though, I will have a play with the reverse dns lookups and see if that helps. Andy Moore Selima Software Ltd. -Original Message- From: Don Verhagen [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 17:53 To: [EMAIL PROTECTED] Subject: RE: [U2] UVODBC first query I know this happens even with TELNET on Window Servers. It has something do with the first time it looks up a username in the doman and then it caches the the user tree (probably wrong term) of all the users. So each login after than does NOT have to retrieve a list of users. Does that make sense? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 >>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>> 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 281 > 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/ --- 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/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC first query
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. The telnet connections aren't affected by the same delay that the UVODBC is. And as far as I know we are using the server's IP in the UVODBC configuration. We also found on Windows servers that including the full path to the account you are connecting to instead of just the account name also improves performance, but it still doesn't remove the first query pause. Thanks for the suggestions though, I will have a play with the reverse dns lookups and see if that helps. Andy Moore Selima Software Ltd. -Original Message- From: Don Verhagen [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 17:53 To: [EMAIL PROTECTED] Subject: RE: [U2] UVODBC first query I know this happens even with TELNET on Window Servers. It has something do with the first time it looks up a username in the doman and then it caches the the user tree (probably wrong term) of all the users. So each login after than does NOT have to retrieve a list of users. Does that make sense? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 >>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>> 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 281 > 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/ --- 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/
RE: [U2] UVODBC first query
That rings a bell. A few years ago, before we get a network admin who knew what he was talking about, we had terrible performance problems with Universe sockets when using host names; if we used direct IP addresses it was perfect. He said it was down to RARP not being configured properly in the network. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian McGowan Sent: 09 September 2004 21:50 To: '[EMAIL PROTECTED]' Subject: RE: [U2] UVODBC first query A common cause of long delays when first connecting is reverse dns lookups. Your PC is 192.168.1.100 and you're telneting to a server. It does a lookup of 192.168.1.100 to record the host name and it can take a while for dns to come back that it doesn't exist. The dns query is cached, so connecting a few minutes later is fast. The best solution is to setup a reverse lookup domain, but adding dummy records to /etc/hosts (or %systemroot%\system32\drivers\etc\hosts) like: pc100 192.168.1.100 pc101 192.168.1.101 Works too. If "nslookup 192.168.1.100" doesn't return your pc host name, then this might be worth checking... > -Original Message- > From: Adrian Matthews [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 09, 2004 12:21 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] UVODBC first query > > > Are you sure? Certainly doesn't happen on any of our servers, > connection is near enough instant whether via telnet, > uniobjects or JDBC. > > > > From: [EMAIL PROTECTED] on behalf of Don Verhagen > Sent: Thu 09/09/2004 17:52 > To: [EMAIL PROTECTED] > Subject: RE: [U2] UVODBC first query > > > > I know this happens even with TELNET on Window Servers. It > has something do with the first time it looks up a username > in the doman and then it caches the the user tree (probably > wrong term) of all the users. So each login after than does > NOT have to retrieve a list of users. Does that make sense? > > Thanks, > > > -- > Donald Verhagen > Application Development Manager > [EMAIL PROTECTED] > Tandem Staffing Solutions, Inc. > 1690 S Congress Avenue, Suite 210 > Delray Beach, FL 33445 USA > Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 > > >>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>> > 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 281 > > 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/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > The information contained in t
RE: [U2] UVODBC first query
At 01:50 PM 9/9/2004, you wrote: A common cause of long delays when first connecting is reverse dns lookups. On the last project I worked on, we found that using the IP address for the system name eliminated this problem. We found ODBC to be too slow in the long run, though and switched to OleDB. Thanks, Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC first query
A common cause of long delays when first connecting is reverse dns lookups. Your PC is 192.168.1.100 and you're telneting to a server. It does a lookup of 192.168.1.100 to record the host name and it can take a while for dns to come back that it doesn't exist. The dns query is cached, so connecting a few minutes later is fast. The best solution is to setup a reverse lookup domain, but adding dummy records to /etc/hosts (or %systemroot%\system32\drivers\etc\hosts) like: pc100 192.168.1.100 pc101 192.168.1.101 Works too. If "nslookup 192.168.1.100" doesn't return your pc host name, then this might be worth checking... > -Original Message- > From: Adrian Matthews [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 09, 2004 12:21 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] UVODBC first query > > > Are you sure? Certainly doesn't happen on any of our servers, > connection is near enough instant whether via telnet, > uniobjects or JDBC. > > > > From: [EMAIL PROTECTED] on behalf of Don Verhagen > Sent: Thu 09/09/2004 17:52 > To: [EMAIL PROTECTED] > Subject: RE: [U2] UVODBC first query > > > > I know this happens even with TELNET on Window Servers. It > has something do with the first time it looks up a username > in the doman and then it caches the the user tree (probably > wrong term) of all the users. So each login after than does > NOT have to retrieve a list of users. Does that make sense? > > Thanks, > > > -- > Donald Verhagen > Application Development Manager > [EMAIL PROTECTED] > Tandem Staffing Solutions, Inc. > 1690 S Congress Avenue, Suite 210 > Delray Beach, FL 33445 USA > Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 > > >>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>> > 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 281 > > 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/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > The information contained in this email is strictly > confidential and for the use of the addressee only, unless > otherwise indicated. If you are not the intended recipient, > please do not read, copy, use or disclose to others this > message or any attachment. Please also notify the sender by > replying to this email or by telephone +44 (0)20 7896 0011 > and then delete the email and any copies of it. Opinions, > conclusions (etc.) that do not relate to the official > business of this company shall b
RE: [U2] UVODBC first query
Are you sure? Certainly doesn't happen on any of our servers, connection is near enough instant whether via telnet, uniobjects or JDBC. From: [EMAIL PROTECTED] on behalf of Don Verhagen Sent: Thu 09/09/2004 17:52 To: [EMAIL PROTECTED] Subject: RE: [U2] UVODBC first query I know this happens even with TELNET on Window Servers. It has something do with the first time it looks up a username in the doman and then it caches the the user tree (probably wrong term) of all the users. So each login after than does NOT have to retrieve a list of users. Does that make sense? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 >>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>> 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 281 > 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/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC first query
I know this happens even with TELNET on Window Servers. It has something do with the first time it looks up a username in the doman and then it caches the the user tree (probably wrong term) of all the users. So each login after than does NOT have to retrieve a list of users. Does that make sense? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 >>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>> 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 281 > 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/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC first query
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 281 > 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/