| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Data from WF DB and Application DB |
« View previous topic :: View next topic » |
| Author |
Message
|
| tsrisudh |
 Posted: Mon Oct 10, 2005 9:42 pm Post subject: Data from WF DB and Application DB |
 |
|
Centurion
Joined: 11 Aug 2005
Posts: 113
|
Our application works on orders, we store the order id in the wf datastructure for each activity, when the orders have to be shown on the web page we have to get more details of the order from the application database.
My problem is we fetch around 100 orders each time from workflow activity and then have to apply the order_id in (1, 2, ......) in the query to get other data from application DB. With the number of orders increasing, the query to get the application data is slowing down, is there any other better way to handle this scenario?
_________________
Srisudhir Tadepalli |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon Oct 10, 2005 10:48 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
You stated that you are getting 100 orders at a time...does that mean you are limiting your workitem query to 100 activities ?? If yes then the time should always be the same for every time you have 100 to fetch.......
I dont think this is a Workflow issue, but simply a DB2 one......if the delay is in getting the 100 workItem id's from the worklist, then we could ponder why, but the issue seems to be getting it from ur application database, which i suppose some Java/C application is doing....
Is this application running on WSAD or something....... |
|
| Back to top |
|
|
| tsrisudh |
| Posted: Tue Oct 11, 2005 3:11 am Post subject: |
|
|
Centurion
Joined: 11 Aug 2005
Posts: 113
|
the number of orders started with 100 but is increasing by the day as of now we have around 200.
We fetch all of the workitems from workflow each time.
Yes i agree that the problem is with our application db2, my question was is this the way applications do it(get order ids from wf and query own database for rest) or do they hold all data in the workflow itself? or is there any better way to do this?
_________________
Srisudhir Tadepalli |
|
| Back to top |
|
|
| supreeth |
| Posted: Tue Oct 11, 2005 3:25 am Post subject: |
|
|
Voyager
Joined: 17 May 2005
Posts: 90
Location: London
|
Hi,
I suggest you have the required data in the workflow containers itself and u build your activity description in a suitable way so that you get all the information required available in the description itself.
For eg: if i have a data structure named ORDERS with its definition as below
ORDERS
orderid int
category varchar
rate int
I would be building my activity description something like this:
Order Id is %orderid%. Category is %category%. Rate is %rate%
This is just a sample description. If you can build your description in a manner suitable to you, you can directoly print the description on the screen or you may have to do some minor parsing logic to figure out the data. This is anyday better compared to accessing another application database.
Also, the advantage with having it in the description is that u need not do an explicit look into the container of the queried workitem like
category=workitem[x].getString("category");
Thanks and Regards,
Supreeth
_________________
Supreeth Gururaj
IBM Certified WMQ Solution Expert |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
