Re: VFP8 & MySQL

From: Ook (usenet_at_nospam.zootal.nomorespam.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 08:12:30 -0800

It would be in your best interest to verify that xCase2VPM did indeed get
the datatypes correct. If it looks at your local tables to create the remote
views, then you are probably OK. If it takes your local views and converts
them to remote views assuming the same data types, then you should be OK. If
it looks at the MySQL tables to deterine data types, then you might have
problems.

"Edhy Rijo" <erijo@msn.com.NO_SPAM> wrote in message
news:%23ALCxMrFFHA.3608@TK2MSFTNGP14.phx.gbl...
> Hi Ook,
>
> Thanks for sharing your experiences. For now I am very happy with the
> combination of tools, I am using VPME81, xCASE, xCASE2VPM & VisualRep.
> xCase2VPM will take care of creating the remote views and converting some
> VFP functions like NVL to a MySQL one, definitely it made the switch very
> easy to do, VisualRep also worked as advertised, I create the queries
> against the backend tables and the performance is pretty good, VisualRep
> allows you to create parameters to the queries which acts like a
> parameterized view, so all data is filtered with great power. I have one
> Main Location and 3 branches (these are remotely accessing MySQL at the
main
> location via TCP/IP). I am using the latest version of all the tools til
> now and I love this one EMS MySQL ManagerT
> http://www.sqlmanager.net/products/mysql/manager it makes handling day to
> day maintenance pretty easy via a filtered grid (like VFP Browse) where I
> can manually modify or delete records just like we do in VFP and this tool
> allowed me to import a .CSV file I exported from my VFP Tables to MySQL
with
> a very good data manipulation.
>
> About your connection problem, I have mine setup as default for 100
> connections, but I will keep an eye on that since in the main location
there
> are 8 users entering transactions all day. In the next weeks I will
upgrade
> it to VPM9/VFP9 where we can take advantage of the share connection and
play
> with database replication which may be a good option for the branches
where
> they can have a MySQL server locally and this would replicate itself to
the
> main location allowing the branches to work offline if the Internet
> connection is down.
>
> Anybody else with more experiences to share??????
>
> --
> Edhy Rijo
> www.progytech.com
> Bronx NY
> ProMatrix MVP Life
>
>
> "Ook" <MSNews@emberts.UpYoursSpammer.emberts.com> wrote in message
> news:ey3e6sqFFHA.1936@TK2MSFTNGP14.phx.gbl...
> > Edhy, the only problem I had was when creating the remote views. The
MySQL
> > ODBC driver does not talk to VFP very well, and I had a lot of problems
> > with the datatypes in the remote view sql. I had to manually edit many
of
> > them to be what I wanted them to be. As for the server, we left it
alone.
> > The only time we had problem was when we tried to add an index to a 5GB
> > MySQL table. The server crashed and corrupted the database. There is a
> > setting on the my.cfg (I think) that increases some memory buffer, but
> > I've long since forgotten what it is).
> >
> > I used MySQL with VPME8, and it worked very well. I was very happy with
> > the performance, and somewhat surprised that it actually worked as well
as
> > it did.
> >
> > OH, yeah, I remember a problem. When I would run a form, it would open a
> > dozen or more connections to the MySQL database. Depending on what the
> > user was doing, there could easily be 20 or 30 connections to the
> > database. After 3 or 4 users logged in, they started to get some sort of
> > no more available connection error. You have to find the max concurrent
> > connection limit on the MySQL server and increase it. I think I set it
to
> > 10240, and we didn't have any more problems. This worries me - what
would
> > happen if we had hundreds, or maybe thousands of users hammering the
> > database? I think there is a fundamental flaw with the strategy I was
> > using, because of this concurrent connection limit. Eventually we would
> > have had to write some sort of data layer to run between the client and
> > the database server, but I left the company before we got to that point.
> >
> >
> > "Edhy Rijo" <erijo@msn.com.NO_SPAM> wrote in message
> > news:%23dWOupjFFHA.1392@tk2msftngp13.phx.gbl...
> >> Hi All,
> >>
> >> I am using VFP8 with MySQL 4.1.9 and would like to heard from VFP users
> >> of MySQL if there are any flags that should be
> >> set in the Server to optimize the database?
> >>
> >> Also anything other than default settings for the connection in the
> >> remote database?
> >>
> >> So far my application is working fine, just wanted to be prepare to
> >> anything <s>.
> >>
> >> Thanks!
> >> --
> >> Edhy
> >>
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)