Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Muhammad Majid Ali Attari
  Where is Muhammad Majid Ali Attari?
 Hyderabad
 Pakistan
 Muhammad Majid Ali Attari
 Tags
Subject: RE: Slow Reponse From DB Server
Thread ID: 344602 Message ID: 345062 # Views: 22 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, May 17, 2012 6:22:45 PM         
   


> >
> >
> > Hi,
> > Sounds like a networking disconnect issue to me.
> > - NIC card or drivers.
> > - Network cabling.
> > - On one workstation only, check NIC card and drivers on that workstation.
> > - As a simply test try copying a 40-50 Meg file or files from server to workstation and see what happens.
> > Repeat the above copy 5-6 times and see if you get an error in copying.
> > Pete "the IceMan", from the Great White North of Canada.
> > www.marathongriffincomputers.com
>
> netwrok is perfect. i was trying to figure it out. i was not applying SQLDISCONNECT() at exit of my app assuming that the connection will be ended automatically. i came to know that if i you dont terminate a connection to postgre server, it has been left open. although i could not watch those left open connections in server status window. but i applied it and added SQLDISCONNECT() at exit of app. it has been 3 days, client has not complained for slow response of server. hoping that i applied the right and learned a new lesson.
> well Pete, thanx 4 ur time. if i get any update, i will bother this thread again. thanx again
>
> Regards,
>
> Muhammad Majid Ali Attari


Hi,]
Glad you found the issue. Yes in your case you could have been leaving multiple connection open if you never closed them and this will cause an issue.
Pete "the IceMan", from the Great White North of Canada.
www.marathongriffincomputers.com

ENTIRE THREAD

Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/11/2012 9:13:48 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/11/2012 5:02:20 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/12/2012 7:21:34 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/12/2012 11:03:48 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/14/2012 7:13:04 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/14/2012 2:49:10 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/15/2012 7:30:32 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/15/2012 2:15:30 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/17/2012 6:54:52 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/17/2012 6:22:45 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/14/2012 7:34:34 AM
RE: Slow Reponse From DB Server Posted by anand kulkarni @ 5/14/2012 7:45:39 AM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/15/2012 7:32:14 AM
RE: Slow Reponse From DB Server Posted by anand kulkarni @ 5/15/2012 11:07:57 AM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/17/2012 6:55:51 AM
RE: Slow Reponse From DB Server Posted by anand kulkarni @ 5/17/2012 7:08:04 AM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/17/2012 11:28:23 AM