MQSeries.net :: View topic - Query Efficiency

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » Query Efficiency

Query Efficiency

« View previous topic :: View next topic »

Author

Message

MaheshPN

Posted: Wed Nov 19, 2003 12:59 pm Post subject: Query Efficiency

Master

Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC

Hi Guys,
I have a requirement of querying the process list for specific Visit and suspend it. I can do it either by having the Process instance name or GDC in the criteria.
I am wondering which would give the best result in the future, when there were several thousands of process instances.

Any inputs are appreciated!!

Thanks,

-Mahesh
IBM Certified Solution Expert - MQWorkflow

jmac

Posted: Wed Nov 19, 2003 1:24 pm Post subject:

Jedi Knight

Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC

I would guess that the PI Name would be more efficient.

You might want to post this to the IBM Newsgroup and see what the developers have to say.
_________________
John McDonald
RETIRED

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » Query Efficiency

Jump to:

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

Protected by Anti-Spam ACP