Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 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: 345004 # Views: 26 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, May 17, 2012 7:08:04 AM         
   


> > you Must check the Network card of server,hdd for bad sectors :)
> >
> >
> > 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 !!!
>
>
>
> 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 !!!

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