Hi Experts,
There is a simple select statement in lose focus trigger of a field.
The problem is it takes around 30 secs to execute in uniface but it takes fraction of a second when executed from toad not sure why there is so much of difference in timing ? also u_where clause is used in query which has only a column in it which is primary key on table.
Thanks,
Imran.
+5Hi Experts,
There is a simple select statement in lose focus trigger of a field.
The problem is it takes around 30 secs to execute in uniface but it takes fraction of a second when executed from toad not sure why there is so much of difference in timing ? also u_where clause is used in query which has only a column in it which is primary key on table.
Thanks,
Imran.
You can get the exact SQL generated by UNiface from running it with $ioprint set to 32. This may point to how it is formatting the SQL differently from what you would expect from the selectdb.
If you run the expected (or produced) sql in toad, but with the filter column off (so group by the filter column, but don't filter it, and it takes 30 seconds, that may point to what uniface is doing differently (applying the filter to the resultset instead of part of the query).
Alternatively, you may find there's an improvement if you build the sql yourself and run it as sql/data.
Regards,
Iain
Hi Experts,
There is a simple select statement in lose focus trigger of a field.
The problem is it takes around 30 secs to execute in uniface but it takes fraction of a second when executed from toad not sure why there is so much of difference in timing ? also u_where clause is used in query which has only a column in it which is primary key on table.
Thanks,
Imran.
Thanks for your comments Iain.
I have set $ioprint=32 in asn file and restarted the application but though the query in discussion is executed it is not captured in message window. Below is how query looks
selectdb(count(column_name)) from "table_name" u_where(column_name.table_name = "%%L_VAR") to (L_COUNT)
There many other queries showing in the message window except above. application uses oracle database.
+1Thanks for your comments Iain.
I have set $ioprint=32 in asn file and restarted the application but though the query in discussion is executed it is not captured in message window. Below is how query looks
selectdb(count(column_name)) from "table_name" u_where(column_name.table_name = "%%L_VAR") to (L_COUNT)
There many other queries showing in the message window except above. application uses oracle database.
Hi Experts,
There is a simple select statement in lose focus trigger of a field.
The problem is it takes around 30 secs to execute in uniface but it takes fraction of a second when executed from toad not sure why there is so much of difference in timing ? also u_where clause is used in query which has only a column in it which is primary key on table.
Thanks,
Imran.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
