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
EMAIL PROTECTED]>
Sent: Thursday, December 05, 2002 5:06 AM
Subject: RE: access->mysql
thnx to all!
am checking this links out.. looks great! :)
-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: quinta-feira, 5 de Dezembro de 2002 12:30
To: MySQL List
Subje
thnx to all!
am checking this links out.. looks great! :)
-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: quinta-feira, 5 de Dezembro de 2002 12:30
To: MySQL List
Subject: Re: access->mysql
DBTools works great on this matter. You find it at
h
DBTools works great on this matter. You find it at
http://www.dbtools.com.br/EN and is totally free.
[]s
Crercio
- Original Message -
From: "Sandeep Murphy" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, December 04, 2002 12:39 PM
Subject: access->mysql
Hi,
I can concur - you pay a little, but you get a much better product with this one.
Ian Zabel wrote:
> The only one I found that creates a good schema that only needs minimal
> massages, and imports all the data correctly is Access-To-MySQL. It's
> not free though, but they have a trial. Once I wen
I have used Access to MySQL pro and it worked for a few of my databases.
http://www.convert-in.com/acc2sqlp.htm
Chris
-Original Message-
From: Sandeep Murphy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 8:39 AM
To: MySQL List
Subject: access->mysql
Hi,
Can anyone pleas
On Wed, 4 Dec 2002 14:39:01 -, Sandeep Murphy wrote:
>method for converting a huge database i hv in Access xp to MySQL ??
>
I just wrote a short program in Delphi (using MyODBC) to pull
information from an Access MDB and update a MySQL table. Worked fine.
I'm sure one could accompli
The only one I found that creates a good schema that only needs minimal
massages, and imports all the data correctly is Access-To-MySQL. It's
not free though, but they have a trial. Once I went through my access
database and removed certain invalid records (some rows had a screwed up
primary key in
I used MySQLFront. It wasn't entirely automatic, but it did a reasonable
job. There are some gotchas.
Take your time, and be sure to read the notes for using Access and MyODBC
with MySQL, if that's how you're going to do it -- some column types are not
recommended. You'll want to add a TIMEST
I saved the email last time this was posted, didn't look into it but someone
suggested looking at this site. http://www.intranet2internet.com . Another
option was to link the table, not exactly sure of all the steps but maybe
create an empty table in mysql with all fields and data types, then set u
On Mon, 28 Oct 2002, aman mysql wrote:
> Hi all
> How do I access a remote MySQL server (on LINUX platform), from a windows
> application.
> What drivers I need to download and from where?
Hi!
You don't need any special drivers. Just the MySQL command-line client will
do the job. It can be downl
Another option might be ursql (http://www.urbanresearch.com/ursql). This
tool has the ability to generate MySQL-compatible CREATE TABLE scripts
from a connected MS Access database. Once the basic CREATE TABLE scripts
are generated, you can easily tweak the data types to your liking.
In my exper
I too am researching how to do this. I've found plenty of products that will
do this, of course, I'd rather do it myself.
here's some links i've found:
http://www.convert-in.com/acc2sqlp.htm
http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp
http://www.winmysql.com/
i hope
denis mettler wrote:
>
> Hi,
>
> i have a mysql db on suse linux 7.1
> only one table without primary key.
>
> then i inserted data via load data local infile
> everything was fine.
>
> then i altered table and added a primary key
> everythings fine, too.
>
> i'm searching for results
24 matches
Mail list logo