You do not have to compromise. If reliability and speed is what you want,
then if you find US to produce faster results, set up mysql in the US with
replication locally. And yes, I agree, don't rely on access for stability.
If you want stability, go with mysql on a unix based system. Your location
and "ISP" will determine the speed factor.
----- Original Message -----
From: "Jonor Lacuesta" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 11:22
Subject: Re: WEB to remote MySql server
> Well, I'm looking at reliability more than speed and I'm afraid that MS
> Access just won't be up to it.
> I'll look for the migrating tools you mentioned, but i feel that any
effort
> now is better than having to rescue data later on.
>
> Connection in the philippines can't beat acccessing your data on your
> localhost, so guess i have to look for a compromise between speed and
> reliability.
>
> Thanks, Rolf.
>
> At 10:54 AM 2/7/2001, Rolf Hopkins wrote:
> >What you will need to consider more is
> >
> >1. The effort required to migrate across to mysql. There are tools that
can
> >assist but I don't know the URLs. Maybe someone else on the list knows.
> >
> >2. What will be faster for the majority of users and I'm talking about
> >overall performance. If having it locally in the Phillipines is faster
than
> >by all means, transfer it across.
> >
> >----- Original Message -----
> >From: "Jonor Lacuesta" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Tuesday, February 06, 2001 12:23
> >Subject: WEB to remote MySql server
> >
> >
> > > Hello,
> > >
> > > I would just like to ask the list's members of this setup:
> > >
> > > We have rented a Win2000 web server in the US with a 50GB
transfer/month
> >in
> > > the internet. The server currently holds our site's asp web
> > > files, SMTP/POP server and MS Access database files. The Access files
> > > holds the list of users of our asp pages and allowed email users. Our
web
> > > application presents a login form which is checked against the list of
> > > users in the database. Everytime a member logs in or signup, the
Access
> > > database will be used.
> > >
> > > Over here in the Philippines, I have several servers each more
powerful
> > > than the one in the US except that our internet connection is only
128kbps
> > > with burst of up to 256kbps.
> > >
> > > I plan to distribute the load of the US server by moving some of the
> > > services to our local facilites.
> > >
> > > Will there be connection problems if I move the database to a MySql
server
> > > to our local site an still retain the web server in the US? Or is it
> >better
> > > to have MySql running in the US server and have a duplicate or slave
> >MySql
> > > server here in our local site. I also plan to move the email servers
here
> > > and email users will also be checked against the database.
> > >
> > > Thanks in advance.
> > >
> > > *************************
> > > Jonor Lacuesta
> > > Systems Administrator
> > > Philippinemail.com
> > >
> > > "Send free postal letters to the Philippines FREE"
> > > http://www.philippinemail.com
> > >
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> ><[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >---------------------------------------------------------------------
> >Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> >To request this thread, e-mail <[EMAIL PROTECTED]>
> >To unsubscribe, e-mail
> ><[EMAIL PROTECTED]>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> *************************
> Jonor Lacuesta
> Systems Administrator
> Philippinemail.com
>
> "Send free postal letters to the Philippines FREE"
> http://www.philippinemail.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
