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
:
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
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
Neil Tompkins wrote:
The problem appears to be retrieving the data which is slow.
Are you sure it's not the actual query that's slow?
If you run the query in mysql (ie through the command prompt) is it fast?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
of this remote update, would we see a problem if we
queried the mysql database from webpages from another ISP ?
Date: Thu, 10 Aug 2006 16:09:29 -0500 From: [EMAIL PROTECTED] To: [EMAIL
PROTECTED] Subject: Re: Access mySQL database across Internet CC:
mysql@lists.mysql.com A good point to make here
?
Date: Thu, 10 Aug 2006 16:09:29 -0500
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Access mySQL database across Internet
CC: mysql@lists.mysql.com
A good point to make here is that averages are generally
a poor
calculation to use when
On Fri, 11 Aug 2006 15:02:12 +, 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
Neil, in theory, this should work fine, given sufficient bandwidth
between the two sites.
In practice, if it is a high traffic site generating a large number of
connections, or a high traffic site pulling large pieces of data
(BLOBs or TEXT) from the remote database, you may find performance to
What would you assume to be high traffic ? 1000 hits per day or more ?
Date: Thu, 10 Aug 2006 13:05:11 -0500 From: [EMAIL PROTECTED] To: [EMAIL
PROTECTED] Subject: Re: Access mySQL database across Internet CC:
mysql@lists.mysql.com Neil, in theory, this should work fine, given
sufficient
, then you're talking high traffic!
Dan
On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote:
What would you assume to be high traffic ? 1000 hits per day or more ?
Date: Thu, 10 Aug 2006 13:05:11 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC
] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com Neil, in theory, this should work fine, given
sufficient bandwidth between the two sites. In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling
11 matches
Mail list logo