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 unsu
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 establishin
AIL 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 " "@ashcomp.net> Subject: RE: Access mySQL database across Internet> Date: Fri, 11 Aug
2006 12:20:19
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 " "@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 +, 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
ges 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 is that averages are
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>
t; 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 bandwidth> between the two sites.> > In practice,
o 1000 hits / minute, 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]>
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, t
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
b
11 matches
Mail list logo