General information
Title:
CREATE SQL VIEW taking a very long time
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only