Re: VFP8 & MySQL

From: Edhy Rijo (erijo_at_msn.com.NO_SPAM)
Date: 02/19/05 

Date: Sat, 19 Feb 2005 13:45:40 -0500

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)