You shouldn't do in that way, the creation of views is only to stablish the definition and just use it, with runtime view creation you will have a DBC Bloat!!

Of course that the SPT will be always faster when you have to send a lot of dynamic SQL Sentences.

>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