MQSeries.net :: View topic - FMC00817E The result of the query is larger than allowed

muralihegde · Posted: Mon Dec 19, 2005 10:45 pm Post subject:

Hi,
We are using MQ WF V3.5 with SP5 on Windows. We are using a custom built J2EE client that queries the work items using the java APIs. Recently we came across a situation where there were around 2000 work items created for a particular user. So we get the following exception.
FMC00817E The result of the query is larger than allowed.

I understand that this can be remedied by increasing the value for MAXIMUM_QUERY_MESSAGE_SIZE and MAXIMUM_MESSAGE_SIZE at the domain level. But we will have to do similar changes at MQ Q level as well.
1) But increasing this value from the default of 1MB, will it negatively impact the performance? especially when the number of work items created will be fairly less.
2) Does increasing these values imply we need to change any settings at memory etc?
3) As per the customer requirement, we can not put any more filtering on the query, but what is the effect of specifying the threshold to say a value n? Does it retrieve only the first n work items? Is there a way where we can get the next n work items etc?

Thanks and regards,
-Murali