>But to create view.
>
>If it has 1 line (in the MySql) is fast (either in create view or use < view >).
>If it has the 140,000 (In the MySql) commands with view (only in the construction) are slow.
>
>I tried to use CA, but I did not obtain to make it to be update (it gives a strange error). It seems that the VFP does not function well if will not be SQLServer or Oracle :(
>
>If SQLServer ou oracle, all rigth, remote view and CA, but Mysql or Postgresql...

This sounds like the process the ODBC driver uses to return the SQLTABLES in MySql is slow when a large amount of records is in the database. I would not expect this, as you did not.

How many table structure changes, stored procedure changes have been made, that the SQLTABLES command has to go through to get the data out of the 140,000 record database, compared to the same in the 1 record database?

VFP functions very well, when the ODBC driver isn't limiting the functionality.

Run the following code on the two databases. Change the first two lines accordingly. You'll get a better idea of where your slowdown is.

cDataBaseName   = << DataBase >>
cConnectionName = << Connection in Database >>
Open Database (cDataBaseName)
dConnectStart = datetime()
nSqlConnect = SQLCONNECT(cConnectionName)
dConnectEnd = datetime()
dTableStart = datetime()
nSqlResults = SQLTABLES(nSqlConnect,"TABLE")
dTableEnd   = datetime()
SQLDISCONNECT(nSqlConnect)
cMessage    = "Elapsed: " + TRANSFORM(dTableEnd - dConnectStart) + CHR(13) + CHR(10) ;
            + "Connect: " + TRANSFORM(dConnectEnd - dConnectStart) + CHR(13) + CHR(10) ;
            + "Query: " + TRANSFORM(dTableEnd - dTableStart)
=MESSAGEBOX(cMessage)