| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Ineraction between Java API and Runtime |
« View previous topic :: View next topic » |
| Author |
Message
|
| kutulu2000 |
 Posted: Wed Aug 30, 2006 3:50 pm Post subject: Ineraction between Java API and Runtime |
 |
|
Acolyte
Joined: 08 Nov 2005
Posts: 63
Location: Mexico
|
Hi again and thanx for your time.
I want to know if the call to the method queryWorkItems performs a search into the FMC.WORK_ITEM. If this is true, exists an index in this table to get faster performance on the search? If not, what must be the way to speed up the performance in this serches?
The problem is that I have too many workitems created every day, and the searches by this way become slow.
Thanx
_________________
#10 |
|
| Back to top |
|
 |
| jmac |
| Posted: Thu Aug 31, 2006 6:04 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I believe you can put an index on the table to speed things up. If you do, I would recommend that you check with IBM to ensure that your index is not going to do any harm.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| kutulu2000 |
| Posted: Thu Aug 31, 2006 12:58 pm Post subject: |
|
|
Acolyte
Joined: 08 Nov 2005
Posts: 63
Location: Mexico
|
mmmmmmm, the company has not renewed the license of this product, so I'm not sure that IBM can assist us. I have another question, Do you know how the API performs the searches of the workitems using "DESCRIPTION LIKE .....", I mean, if I have too many data members in the data structure the search in this field is value per value?
Thanx
_________________
#10 |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Aug 31, 2006 2:22 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Any search with Like is going to be slow. You would very likely benefit from indexes, and I guess you dont have support anyway, so there is no harm in putting on the index you ( or your DBA ) think would help
_________________
John McDonald
RETIRED |
|
| 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
|
|
|
|
