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