Posted: Thu Jul 18, 2002 7:02 am Post subject: Which node to use for Database operations in WMQI?
Novice
Joined: 19 Dec 2001 Posts: 12
Hi,
I'm trying to perform a database operation in WMQI. Now I'm looking thru the WMQI manuals as well as the redbooks and I am thoroughly confused. I'm noticing that for simple operations such as an insert, I could possibly use 3 different nodes to perform the same operation...DataInsert, Database and Compute.
My question is what advantages/disadvantages are there for using one over the other? Is one node better suited to handle one type of situation over another? I guess I'm just not understanding when to use which node in what situation.
The three nodes will all do the same thing for you, but there are a couple of factors which might help you make your decision.
* When glancing at a flow, using a specialised node such as DataInsert will make it immediately obvious what operation you are performing. (i.e. inserting to a database). This may or may not be important to you
* A Compute node is more flexible if you want to modify the operation in the future.
* Try and minimise the number of nodes in your flow. Everytime you pass through a node you incur some overhead. Having four DataInsert nodes wired together is less efficient than writing four ESQL INSERTs within one compute node.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum