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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]