Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Muhammad Majid Ali Attari
  Where is Muhammad Majid Ali Attari?
 Hyderabad
 Pakistan
 Muhammad Majid Ali Attari
 To: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 Tags
Subject: RE: Slow Reponse From DB Server
Thread ID: 344602 Message ID: 345021 # Views: 25 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, May 17, 2012 11:28:23 AM         
   


> >
> >
> >
> > netwrok is perfect. hdd is also flying. 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 Anand 'G', thanx 4 ur time. if i get any update, i will bother this thread again. thanx again
> >
> > Regards,
> >
> > Muhammad Majid Ali Attari
> Yes Majid ,
> when you open a sql connection the for next time of opeing you have to close 1st opened connection Else it will open n Number of unclosed connection . As you told on new machine it is running ok but due to this connection problem after short while it will happen same . You found right bug ( May be :) ) .
> i here use this for mysql spt opening connection
> Before opening connection i use SQLDISCONNECT(0) . :)
>
>
>
> regards
> Anand S. Kulkarni
>
> When it rains ... all Birds occupy shelter , but Eagle is the only bird with its capacity to fly over the sky to avoid rains !!!

Anand ur approach will be very useful if SQLDISCONNECT(0)'s scope in on a whole PC. if its scope is within current session it wont be able to close all opened connections (which do not have a handle) on a PC. suppose on a client PC, a user dbl clicks the APP and later he exits but connection is still opened coz sqldisconnect was not applied. in this scenario if user again dbl clicks the APP to run again and if ur approach is applied will it swap out all opened connections of this client machine 1st? if sqldisconnect scope on whole PC than very usefull and if within session of app all opened connections wont be swaped out. what do you think?

Regards,

Muhammad Majid Ali Attari

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