Hi all :

I making a program that connects to a remote MySQL Server.

In the server, there is a table with 189000 records, and when a issue a "CREATE SQL VIEW cView REMOTE CONNECTION cConnection SHARE AS select count(*) from cTable" takes about 10,15 seconds to execute this simple line.
Whatever the SELECT statment that i issue in the CREATE SQL VIEW (small group of records), the result is always the same... 10 or 15 seconds.

(The SQLEXEC is light speed executed)

What am I missing ?

thanks