I observed two popular approaches to work with database using myWebmethods 7.0
a) The built-in Database Connector
b) The java JDBC code that uses ISqlWorker and jdbc classes.
Option a) seems to be good and generic for results from a SELECT queries
Option b) seems to work well when we have to collect information from user esp in UPDATE/DELETE/INSERT actions and the user submits a form with lot of inputs. I can use this option for SELECT queries aswell.
My question now is: w.r.t Asynch tables? which one is more optimized.