The problem appears to be retrieving the data which is slow.
> Date: Tue, 15 Aug 2006 11:32:23 -0500> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> Subject: Re: Access mySQL database across Internet> CC: > mysql@lists.mysql.com> > You could look into establishing persistent > connections. Know it's> possible with mod_perl and I believe PHP. Not sure > about ASP.> > Basically, this leaves a connection always open, eliminating > the> overhead of resolving host, connecting, authenticating, switching to> > the proper database. Not really a lot of time saved but for a> high-volume > site it can make a difference; also may help if you are> experiencing network > latency.> > Is establishing a connection what you feel is slow? Or the > transfer> of data between your servers is what's slow?> > Dan> > On 8/15/06, > Neil Tompkins <[EMAIL PROTECTED]> wrote:> > The connection time to my mySQL > database is OK from the ASP page. Are there any ways to speed this up though > ?> >> > > From: [EMAIL PROTECTED]> To: My.SQL " > <mysql@lists.mysql.com>"@ashcomp.net> Subject: RE: Access mySQL database > across Internet> Date: Fri, 11 Aug 2006 12:20:19 -0400> > On Fri, 11 Aug 2006 > 15:02:12 +0000, Neil Tompkins wrote> > At the moment our mysql server hosted > by an ISP, is updated every > > second by a program running on our local > Internet connection from > > our own office network. We have seen no > performance issues from our > > websites hosted by the same ISP running our > mySQL server.> > That's fairly impressive, but I hope you mean that you only > *consider* > updating once per second, if actually necessary. It would be an > awful lot > of wasteful traffic if you actually had the two machines talking > every > seconed to transmit nothing.> > Barry> > -- > MySQL General Mailing > List> For list archives: http://lists.mysql.com/mysql> To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]>> > > _________________________________________________________________> > Be one > of the first to try Windows Live Mail.> > > http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d> > > _________________________________________________________________ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d